SELECT * FROM table_name;
SELECT * FROM TABLE_NAME;
SELECT column1, column2, ... FROM table_name;
SELECT column-names FROM table-name1 WHERE value IN (SELECT column-name FROM table-name2 WHERE condition)
SELECT column1 = (SELECT column-name FROM table-name WHERE condition), column-names FROM table-name WEHRE condition
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>]