SELECT * FROM table_name;
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>] /* Specifically for SQL -> Oracle LEGEND: [...] : optional entries <...> : your specific entry */
SELECT * FROM TABLE_NAME;
SELECT column_name 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)
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>]
SELECT column1 = (SELECT column-name FROM table-name WHERE condition), column-names FROM table-name WEHRE condition