The Complete SQL Dictionary
Get clear syntax, use cases, and examples of every useful SQL function you need to find insights and automate your data.
Categories
SQL SELECT
Basic statements and clausesSQL LIMIT
Basic statements and clausesSQL WHERE
Basic statements and clausesSQL ORDER BY
Basic statements and clausesSQL CASE
Basic statements and clausesSQL GROUP BY
Basic statements and clausesSQL HAVING
Basic statements and clausesSQL IF
Basic statements and clausesSQL WITH
Basic statements and clausesSQL Aliases
Basic statements and clausesSQL Comments
Basic statements and clausesSQL Equal To
Comparison operatorsSQL Not Equal To
Comparison operatorsSQL Greater Than
Comparison operatorsSQL Less Than
Comparison operatorsSQL Greater Than or Equal To
Comparison operatorsSQL Less Than or Equal To
Comparison operatorsSQL COUNT
Aggregate functionsSQL AVG
Aggregate functionsSQL SUM
Aggregate functionsSQL DISTINCT
Aggregate functionsSQL MIN
Aggregate functionsSQL MAX
Aggregate functionsSQL ABS
Aggregate functionsSQL ROUND
Aggregate functionsSQL POWER
Aggregate functionsSQL SQRT
Aggregate functionsSQL BIN
Aggregate functionsSQL LIKE
Logical operatorsSQL IN
Logical operatorsSQL BETWEEN
Logical operatorsSQL IS NULL
Logical operatorsSQL IS NOT NULL
Logical operatorsSQL AND
Logical operatorsSQL OR
Logical operatorsSQL NOT
Logical operatorsSQL NVL
Logical operatorsSQL COALESCE
Logical operatorsSQL EXISTS
Logical operatorsSQL DECODE
Logical operatorsSQL NULLIF
Logical operatorsSQL LNNVL
Logical operatorsSQL NANVL
Logical operatorsSQL INTERVAL
Logical operatorsSQL % Wildcard
Wildcard operatorsSQL _ Wildcard
Wildcard operatorsSQL [] Wildcard
Wildcard operatorsSQL - Wildcard
Wildcard operatorsSQL JOIN
JoinsSQL LEFT JOIN
JoinsSQL RIGHT JOIN
JoinsSQL OUTER JOIN
JoinsSQL FULL OUTER JOIN
JoinsSQL FULL JOIN
JoinsSQL SELF JOIN
JoinsSQL UNION
JoinsSQL JOIN ON
JoinsSQL JOIN WHERE
JoinsSQL Common Table Expression (CTE)
Database functionsSQL Stored Procedures
Database functionsSQL Create Database
Database functionsSQL Drop Database
Database functionsSQL Backup Database
Database functionsSQL Create Table
Database functionsSQL Drop Table
Database functionsSQL Alter Table
Database functionsSQL Create Index
Database functionsSQL Auto Increment
Database functionsSQL Create View
Database functionsSQL NOW
Date functionsSQL CURDATE
Date functionsSQL CURTIME
Date functionsSQL DATEPART
Date functionsSQL EXTRACT
Date functionsSQL DATE_ADD
Date functionsSQL DATEDIFF
Date functionsSQL DATE_FORMAT
Date functionsSQL UNIQUE
ConstraintsSQL PRIMARY KEY
ConstraintsSQL FOREIGN KEY
ConstraintsSQL CHECK
ConstraintsSQL DEFAULT
ConstraintsSQL NOT NULL
ConstraintsSQL Subqueries
AdvancedSQL Window Functions
AdvancedSQL Pivoting Data
AdvancedSQL ROW NUMBER
AdvancedSQL Row Number Over Partition By
AdvancedSQL Relative Dates
AdvancedSQL SELECT INTO
AdvancedSQL LAST_INSERT_ID
AdvancedSQL SESSION_USER
AdvancedSQL SYSTEM_USER
AdvancedSQL USER
AdvancedSQL String Types
Data formattingSQL Numeric Value Types
Data formattingSQL Date Formatting
Data formattingSQL Conversion Functions
Data formatting