• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Step 3. Databases and SQL > Retrieving Selected Data

Retrieving Selected Data

Most of the time, you will not want to retrieve all the records from a particular table. It is more likely that you will only want to return information that meets a certain criterion such as “Show me all the employees in the marketing department.”

To limit the amount of data that a SELECT statement will return, you use the WHERE keyword to set up a matching criterion. For example, the following SELECT statement


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint