SQL Reference

SQL Reference is a free, complete guide to 762+ SQL statements, functions, clauses, data types, and operators. Every entry includes its full syntax, parameter list, return value, and a working example you can adapt for MySQL, PostgreSQL, SQL Server, or SQLite. Browse by category: SELECT Queries, JOIN Types, Aggregate Functions, String Functions, Numeric Functions, Date/Time Functions, Data Types, DDL Statements, DML Statements, Constraints, Indexes, Views, Transactions, Window Functions, Subqueries, Set Operations, CTE (WITH), Administration, MySQL Specific, PostgreSQL Specific, SQL Server Specific, Oracle Specific, SQLite Specific. Popular starting points include SELECT, SELECT *, SELECT DISTINCT, WHERE, AND / OR / NOT, IN, BETWEEN, LIKE, IS NULL / IS NOT NULL, ORDER BY, LIMIT / OFFSET, GROUP BY, HAVING, CASE, COALESCE, NULLIF, FETCH FIRST / FETCH NEXT, SELECT TOP, SELECT INTO, FOR UPDATE. If you are learning SQL from scratch, the 25 in-depth guides walk through entire topics step by step, from basic SELECT queries to window functions and query optimization. Use the search page to jump straight to any statement, the A–Z index to browse everything, or the SQL playground to run queries live in your browser. The blog publishes deep dives on joins, indexing, and query performance.