Everything in brackets is optional. SELECT [all/distinct] <COL1>, <COL2>, <COL3> FROM <TABLE_NAME> [JOIN <JOIN_CONDITION>] [WHERE <CONDITION>] [GROUP BY <COLUMN_NAME>] [HAVING <SEARCH_CONDITION>] [ORDER BY <SORT_SPECIFICATION>]