SQL Query Statements with Master Query

Name	Statement
SELECT	SELECT column1, column2....columnN FROM   table_name;
DISTINCT Clause	SELECT DISTINCT column1, column2....columnN FROM   table_name;
WHERE Clause	SELECT column1, column2....columnN FROM   table_name WHERE  CONDITION;
AND/OR Clause	SELECT column1, column2....columnN FROM   table_name WHERE  CONDITION-1 {AND|OR} CONDITION-2;
IN Clause	SELECT column1, column2....columnN FROM   table_name WHERE  column_name IN (val-1, val-2,...val-N);
BETWEEN Clause	SELECT column1, column2....columnN FROM   table_name WHERE  column_name BETWEEN val-1 AND val-2;
LIKE Clause	SELECT column1, column2....columnN FROM   table_name WHERE  column_name LIKE { PATTERN };
TOP Clause	SELECT TOP number|percent column_name(s) FROM table_name WHERE [condition]
ORDER BY Clause	SELECT column1, column2....columnN FROM   table_name WHERE  CONDITION ORDER BY column_name {ASC|DESC};
GROUP BY Clause	SELECT SUM(column_name) FROM   table_name WHERE  CONDITION GROUP BY column_name;
COUNT Clause	SELECT COUNT(column_name) FROM   table_name WHERE  CONDITION;
HAVING Clause	SELECT SUM(column_name) FROM   table_name WHERE  CONDITION GROUP BY column_name HAVING (arithematic function condition);
CREATE TABLE	CREATE TABLE table_name( column1 datatype, column2 datatype, column3 datatype, ..... columnN datatype, PRIMARY KEY( one or more columns ) );
DROP TABLE	DROP TABLE table_name;
CREATE INDEX	CREATE INDEX index_name ON table_name ( column1, column2,...columnN);
DROP INDEX	ALTER TABLE table_name DROP INDEX index_name;
DESC	DESC table_name;
TRUNCATE TABLE	TRUNCATE TABLE table_name;
ALTER TABLE	ALTER TABLE table_name {ADD|DROP|MODIFY} column_name {data_ype};
INSERT	INSERT INTO table_name( column1, column2....columnN) VALUES ( value1, value2....valueN);
UPDATE	UPDATE table_name SET column1 = value1, column2 = value2....columnN=valueN [ WHERE  CONDITION ];
DELETE	DELETE FROM table_name WHERE  {CONDITION};
CREATE DATABASE	CREATE DATABASE database_name;
DROP DATABASE	DROP DATABASE database_name;
COMMIT	COMMIT;
ROLLBACK	ROLLBACK;
INNER JOIN	SELECT table1.column1, table2.column2... FROM table1 INNER JOIN table2 ON table1.common_field = table2.common_field;
LEFT JOIN	SELECT table1.column1, table2.column2... FROM table1 LEFT JOIN table2 ON table1.common_field = table2.common_field;
RIGHT JOIN	SELECT table1.column1, table2.column2... FROM table1 RIGHT JOIN table2 ON table1.common_field = table2.common_field;
FULL JOIN	SELECT table1.column1, table2.column2... FROM table1 FULL JOIN table2 ON table1.common_field = table2.common_field;
UNION	SELECT column1 FROM table1 UNION SELECT column1 FROM table1
CREATE VIEW	CREATE VIEW view_name AS SELECT column1, column2..... FROM table_name WHERE [condition];

Master Query

SELECT [ALL | DISTINCT] {select_list}

[INTO [owner.]table]

[FROM [owner.]{table | view}[alias] [HOLDLOCK]

[,[owner.]{table | view }[alias]

[HOLDLOCK]]...]

[WHERE condition]

[GROUP BY [ALL] aggregate_free_expression [, aggregate_free_expression]...]

[HAVING search_condition]

[UNION [ALL] SELECT...]

[ORDER BY {[[owner.]{table | view }.]column | select_list_number | expression}

[ASC | DESC]

[,{[[owner.]{table | view }.]column | select_list_number | expression}

[ASC | DESC]...]

[COMPUTE row_aggregate(column)

[,row_aggregate(column)...]

[BY column [, column...]]]

[FOR BROWSE]

The individual element in the select list is as follows: 

[alias = ]

{* | [owner.]{table | view}.* | SELECT ... | {[owner.]table.column | constant_literal | expression}

[alias]}