SQL Reference - Complete SQL Command Reference
SQL Reference is a complete guide to SQL with 300+ commands, functions, and clauses. Every entry includes syntax, examples, and database compatibility for MySQL and PostgreSQL. The reference covers querying, joins, aggregations, window functions, and DDL operations. Free to use, searchable, and works in any modern browser.
What We Offer
Browse 300+ SQL commands and functions organized by category including queries, joins, aggregations, window functions, string operations, date functions, and DDL. Each entry ships with syntax, copy-paste examples, compatibility notes for MySQL and PostgreSQL, and links to related commands. Filter by category, search by name, and jump between related commands to learn SQL faster.
Popular Categories
- Queries & Joins - SELECT, JOIN, WHERE, GROUP BY, and HAVING
- Aggregations - COUNT, SUM, AVG, MIN, MAX, and window functions
- String Functions - CONCAT, SUBSTRING, REPLACE, and REGEXP
- Date Functions - DATE, NOW, DATEDIFF, and date formatting
- DDL & Schema - CREATE, ALTER, DROP, and index management
About
SQL Reference is built by David Okafor as a free, browser-based reference for database developers and analysts. All content is free to use, requires no account, and covers both MySQL and PostgreSQL syntax.
Visit SQL Reference - Free online tool, no sign-up required.