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

Chapter 44. Basic SQL > The SELECT Statement

The SELECT Statement

SELECT is the most frequently used SQL statement. It retrieves data from one or more tables. At a minimum, SELECT takes two clauses: the data to be retrieved and the location to retrieve it from.

NOTE

Technically, SELECT statements don't even need table names. It is perfectly valid (although uncommon) to do something like this:

SELECT 100 AS id

This statement returns a single row with a single column—data is not retrieved from any table at all.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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