SQL Clauses
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 ...
Get Sams Teach Yourself SQL in 24 Hours, Second 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.