Name
SELECT Statement
The SELECT statement retrieves rows, columns, and derived values from one or many tables of a database.
Platform | Command |
MySQL | Supported, with variations |
Oracle | Supported, with variations |
PostgreSQL | Supported, with variations |
SQL Server | Supported, with variations |
SQL2003 Syntax
The full syntax of the SELECT statement is powerful and complex, but can be broken down into these main clauses:
SELECT [{ALL | DISTINCT}]select_item
[ASalias
][, ...] FROM [ONLY | OUTER] {table_name
[[AS]alias
] |view_name
[[AS]alias
]}[, ...] [ [join_type
] JOINjoin_condition
] [WHEREsearch_condition
] [ {AND | OR | NOT}search_condition
[...] ] [GROUP BYgroup_by_expression
{group_by_columns
| ROLLUPgroup_by_columns
| CUBEgroup_by_columns
| GROUPING SETS (grouping_set_list
) | ( ) |grouping_set
,grouping_set_list
} [HAVINGsearch_condition
]] [ORDER BY {order_expression
[ASC | DESC]}[, ...]]
Keywords
Each of the keywords shown below, except the select_item
clause, is discussed in greater detail in the “Rules at a Glance” section that follows:
- [{ALL | DISTINCT}]
select_item
Retrieves values that compose the query result set. Each
select_item
may be a literal, an aggregate or scalar function, a mathematic calculation, a parameter or variable, or a subquery, but aselect_item
is most commonly a column from a table or view. A comma must separate each item ina list of such items.The schema or owner name should be prefixed to a column’s name when it’s extracted from a context outside of the current user’s. ...
Get SQL in a Nutshell, 3rd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.