Skip to main content
Log inGet a demo

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.

Get started

Categories

SQL SELECT

Basic statements and clauses

SQL LIMIT

Basic statements and clauses

SQL WHERE

Basic statements and clauses

SQL ORDER BY

Basic statements and clauses

SQL CASE

Basic statements and clauses

SQL GROUP BY

Basic statements and clauses

SQL HAVING

Basic statements and clauses

SQL IF

Basic statements and clauses

SQL WITH

Basic statements and clauses

SQL Aliases

Basic statements and clauses

SQL Comments

Basic statements and clauses

SQL Equal To

Comparison operators

SQL Not Equal To

Comparison operators

SQL Greater Than

Comparison operators

SQL Less Than

Comparison operators

SQL Greater Than or Equal To

Comparison operators

SQL Less Than or Equal To

Comparison operators

SQL COUNT

Aggregate functions

SQL AVG

Aggregate functions

SQL SUM

Aggregate functions

SQL DISTINCT

Aggregate functions

SQL MIN

Aggregate functions

SQL MAX

Aggregate functions

SQL ABS

Aggregate functions

SQL ROUND

Aggregate functions

SQL POWER

Aggregate functions

SQL SQRT

Aggregate functions

SQL BIN

Aggregate functions

SQL LIKE

Logical operators

SQL IN

Logical operators

SQL BETWEEN

Logical operators

SQL IS NULL

Logical operators

SQL IS NOT NULL

Logical operators

SQL AND

Logical operators

SQL OR

Logical operators

SQL NOT

Logical operators

SQL NVL

Logical operators

SQL COALESCE

Logical operators

SQL EXISTS

Logical operators

SQL DECODE

Logical operators

SQL NULLIF

Logical operators

SQL LNNVL

Logical operators

SQL NANVL

Logical operators

SQL INTERVAL

Logical operators

SQL % Wildcard

Wildcard operators

SQL _ Wildcard

Wildcard operators

SQL [] Wildcard

Wildcard operators

SQL - Wildcard

Wildcard operators

SQL JOIN

Joins

SQL LEFT JOIN

Joins

SQL RIGHT JOIN

Joins

SQL OUTER JOIN

Joins

SQL FULL OUTER JOIN

Joins

SQL FULL JOIN

Joins

SQL SELF JOIN

Joins

SQL UNION

Joins

SQL JOIN ON

Joins

SQL JOIN WHERE

Joins

SQL Common Table Expression (CTE)

Database functions

SQL Stored Procedures

Database functions

SQL Create Database

Database functions

SQL Drop Database

Database functions

SQL Backup Database

Database functions

SQL Create Table

Database functions

SQL Drop Table

Database functions

SQL Alter Table

Database functions

SQL Create Index

Database functions

SQL Auto Increment

Database functions

SQL Create View

Database functions

SQL NOW

Date functions

SQL CURDATE

Date functions

SQL CURTIME

Date functions

SQL DATEPART

Date functions

SQL EXTRACT

Date functions

SQL DATE_ADD

Date functions

SQL DATEDIFF

Date functions

SQL DATE_FORMAT

Date functions

SQL UNIQUE

Constraints

SQL PRIMARY KEY

Constraints

SQL FOREIGN KEY

Constraints

SQL CHECK

Constraints

SQL DEFAULT

Constraints

SQL NOT NULL

Constraints

SQL Subqueries

Advanced

SQL Window Functions

Advanced

SQL Pivoting Data

Advanced

SQL ROW NUMBER

Advanced

SQL Row Number Over Partition By

Advanced

SQL Relative Dates

Advanced

SQL SELECT INTO

Advanced

SQL LAST_INSERT_ID

Advanced

SQL SESSION_USER

Advanced

SQL SYSTEM_USER

Advanced

SQL USER

Advanced

SQL String Types

Data formatting

SQL Numeric Value Types

Data formatting

SQL Date Formatting

Data formatting

SQL Conversion Functions

Data formatting