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

Chapter 21. Moving from Jet Queries to T... > Writing SELECT Queries in SQL

Writing SELECT Queries in SQL

The heart of SQL is the SELECT statement used to return a specified set of records from one or more tables. The following lines of syntax are used for an SQL SELECT statement that returns a virtual query table (called a result set, usually a Recordset object) of all or selected columns (fields) from all or qualifying rows (records) of a source table:

SELECT [ALL|DISTINCT| DISTINCTROW] [TOP n [PERCENT]] select_list
   FROM table_names
  [WHERE search_criteria]
  [ORDER BY column_criteria [ASC|DESC]]


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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