SELECT

SELECT

SELECT is used to retrieve data from one or more tables (or views). See Chapter 4, "Retrieving Data"; Chapter 5, "Sorting Retrieved Data"; and Chapter 6, "Filtering Data," for more basic information. (Chapters 417 all cover aspects of SELECT.)

• Input

SELECT columnname, ... FROM tablename, ... [WHERE ...] [UNION ...] [GROUP BY ...] [HAVING ...] [ORDER BY ...];