1select [all/distinct] <COL1>, <COL2>, <COL3>
2from <TABLE_NAME>
3[join <JOIN_CONDITION>]
4[where <CONDITION>]
5[group by <COLUMN_NAME>]
6[having <SEARCH_CONDITION>]
7[order by <SORT_SPECIFICATION>]
8
9
10/*
11Specifically for SQL -> Oracle
12
13LEGEND:
14[...] : optional entries
15<...> : your specific entry
16*/
1SELECT *
2FROM INFORMATION_SCHEMA.COLUMNS -- INFORMATION_SCHEMA is an ANSI-standard (American National Standard Institute) set of read-only views which provide information about all of the tables, views, columns, and procedures in a database
3WHERE TABLE_NAME = N'Customers' -- "N" defines the subsequent string (the string after the N) as being in unicode
1Projection = Select the columns in
2a table that are returned by a query
3Selection = Selects the rows in a
4table that are returned by a query
5Join = Brings together data that is
6stored in different tables by
7specifying the link between them
1SELECT column1 = (SELECT column-name FROM table-name WHERE condition), column-names FROM table-name WEHRE condition