| Data Definition | CREATE, DROP, ALTER, | TABLE, INDEX, VIEW, UNIQUE, ADD, DROP, NULL, INTEGER, |
| Data Manipulaton | SELECT, INSERT, DELETE, UPDATE, | DISTINCT, AS, FROM, WHERE, BETWEEN, LIKE, INTO, VALUES, SET, AND, OR, NOT, |
| Group By | GROUP BY, ORDER BY, | HAVING, ASC, DESC, |
| Join | INNER JOIN, LEFT [OUTER] JOIN, RIGHT [OUTER] JOIN, FULL [OUTER] JOIN, | ON, TO, |
| Subquery | IN, EXISTS, | ANY, ALL, |
| Set | INTERSECT, UNION, MINUS, | |
| Group By Functions | ABSOLUTE (ABS), AVG, INT, MAX, MIN, SUM, COUNT | |
| Text Functions | ASC, AT, CHAR (CHR), CHAR_LENGTH (LEN), LOWER, TRIM, SPACE, SUBSTRING (SUBSTR/MID), UPPER, VALUE (VAL) | |
| Date Functions | DATE, DAY, MONTH, YEAR |