SELECT Statement

FROM Clause

Comparison Operators

WHERE Clause

ORDER BY Clause

AND Condition

OR Condition

Combining the AND and OR Conditions

DISTINCT Clause

IN Condition

IS NULL Condition

IS NOT NULL Condition

LIKE Condition

NOT Condition

ALIASES

Joins

BETWEEN Condition

INSERT Statement

UPDATE Statement

DELETE Statement

TRUNCATE TABLE Statement

EXISTS Condition

GROUP BY Clause

COUNT Function

SUM Function

MAX Function

MIN Function

AVG Function

HAVING Clause

SELECT LIMIT Statement

SELECT TOP Statement

UNION Operator

UNION ALL Operator

INTERSECT Operator

MINUS Operator

EXCEPT Operator

Data Types

CREATE TABLE Statement

CREATE TABLE AS Statement

Primary Keys

ALTER TABLE Statement

DROP TABLE Statement

VIEW

GLOBAL TEMPORARY TABLES

LOCAL TEMPORARY TABLES

Indexes

Comments

Literals