The SELECT command uses clauses to specify the details of queries. The following table lists these clauses and provides a brief description of each. For detailed descriptions, follow the links.
| SELECT List (SELECT Statement) | Appears as the first clause in a SELECT statement and determines which columns are output from the source rows |
| FROM Clause (SELECT Statement) | Names the source tables for the query |
| WHERE Clause (SELECT statement) | Defines the criteria that rows must meet to be selected for output |
| GROUP BY Clause (SELECT Statement) | Groups identical output values in the named columns |
| HAVING Clause (SELECT Statement) | Defines criteria that the groups of rows defined in the GROUP BY clause must satisfy to be output by the query |
| ORDER BY Clause (SELECT Statement) | Sorts the output |
| Possibly Nondeterministic Queries | In some cases the same query can produce different output tables on different implementations because of subtle implementation-dependent behaviors; such queries are called possibly nondeterministic queries |