sql query examples

1SELECT  'test1' AS [@class]
2    , ( SELECT  'test2' as [@class]
3        , (SELECT 'Name' FOR XML PATH(''))
4        FOR XML PATH('td'), type)
5    ,(SELECT  'test3' as [@class]
6        , (SELECT 'Value' FOR XML PATH(''))
7        FOR XML PATH('td'), type) 
8FOR XML PATH('tr'), type

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 * FROM users;

1select * from DUAL;

1SELECT columname FROM tablename

1Select REGEXP FROM DUAL