SQL Reference

SQL statements #

• SELECT
• DISTINCT
• WHEREINNER JOIN
• LEFT JOIN
• SELF-JOIN
• GROUP BY
• HAVING
• ORDER BY
• UNION
• INTERSECT
• MINUS
• INSERT
• UPDATE
• DELETE
• CREATE TABLE
• ALTER TABLE
• DROP TABLE
• PRIMARY KEY
• FOREIGN KEY
• NOT NULL
• CHECK
• UNIQUE
• DEFAULT

SQL Operators #

• AND
• OR
• NOT
• LIKE
• BETWEEN
• IS NULL