The Complete SQL Dictionary

SQL SELECT

SQL LIMIT

SQL WHERE

SQL ORDER BY

SQL CASE

SQL GROUP BY

SQL HAVING

SQL IF

SQL WITH

SQL Aliases

SQL Comments

SQL Equal To

SQL Not Equal To

SQL Greater Than

SQL Less Than

SQL Greater Than or Equal To

SQL Less Than or Equal To

SQL COUNT

SQL AVG

SQL SUM

SQL DISTINCT

SQL MIN

SQL MAX

SQL ABS

SQL ROUND

SQL POWER

SQL SQRT

SQL BIN

SQL LIKE

SQL IN

SQL BETWEEN

SQL IS NULL

SQL IS NOT NULL

SQL AND

SQL OR

SQL NOT

SQL NVL

SQL COALESCE

SQL EXISTS

SQL DECODE

SQL NULLIF

SQL LNNVL

SQL NANVL

SQL INTERVAL

SQL % Wildcard

SQL _ Wildcard

SQL [] Wildcard

SQL - Wildcard

SQL JOIN

SQL LEFT JOIN

SQL RIGHT JOIN

SQL OUTER JOIN

SQL FULL OUTER JOIN

SQL FULL JOIN

SQL SELF JOIN

SQL UNION

SQL JOIN ON

SQL JOIN WHERE

SQL Common Table Expression (CTE)

SQL Stored Procedures

SQL Create Database

SQL Drop Database

SQL Backup Database

SQL Create Table

SQL Drop Table

SQL Alter Table

SQL Create Index

SQL Auto Increment

SQL Create View

SQL NOW

SQL CURDATE

SQL CURTIME

SQL DATEPART

SQL EXTRACT

SQL DATE_ADD

SQL DATEDIFF

SQL DATE_FORMAT

SQL UNIQUE

SQL PRIMARY KEY

SQL FOREIGN KEY

SQL CHECK

SQL DEFAULT

SQL NOT NULL

SQL Subqueries

SQL Window Functions

SQL Pivoting Data

SQL ROW NUMBER

SQL Row Number Over Partition By

SQL Relative Dates

SQL SELECT INTO

SQL LAST_INSERT_ID

SQL SESSION_USER

SQL SYSTEM_USER

SQL USER

SQL String Types

SQL Numeric Value Types

SQL Date Formatting

SQL Conversion Functions