SELECT SELECT * SELECT COLUMN1, COLUMN2,... SELECT DISTINCT (COLUMN1) SELECT COUNT(*) Description: Defines columns to display as part of query output. FROM FROM TABLE1, TABLE2, TABLE3,... Description: Defines tables from which to retrieve data. WHERE WHERE COLUMN1 = 'VALUE1' AND COLUMN2 = 'VALUE2' ... WHERE COLUMN1 = 'VALUE1' OR COLUMN2 = 'VALUE2' ... WHERE COLUMN IN ('VALUE1' [, 'VALUE2']) Description: Defines conditions (criteria) placed on a query for data to be returned. GROUP BY GROUP BY GROUP_COLUMN1, GROUP_COLUMN2,... Description: A form of a sorting operation; used to divide output into logical groups. HAVING HAVING GROUP_COLUMN1 = 'VALUE1' AND GROUP_COLUMN2 = 'VALUE2' ... Description: Similar to the WHERE clause; used to place conditions on the GROUP BY clause. ORDER BY ORDER BY COLUMN1, COLUMN2,... ORDER BY 1,2,... Description: Used to sort a query's results. |