ffee All tools
EN 中文 FR DE

SQL Keyword Reference

Clauses, joins, functions and operators in one searchable table, each with a description and a short example.

Search SQL keywords

Showing 0 entries
Examples use standard SQL and work in MySQL, PostgreSQL and SQLite with small dialect differences.

How to use the SQL Keyword Reference

  1. Type a keyword such as join, having or aggregate.
  2. Find the row that matches the thing you want to do.
  3. Adapt the small example to your own table and column names.

Features

Advertisement

More tools

Cron Expression Generator Cron Expression Explainer Regex Cheatsheet HTTP Method Reference Git Command Reference CSS Property Reference HTML Tag Reference ASCII Table Unicode Character Lookup Keyboard Key Codes CSS Units Reference HTTP Header Reference

Frequently Asked Questions

Common questions about the free online sql keyword reference.

WHERE filters individual rows before grouping, while HAVING filters the groups that aggregation produces.
UNION removes duplicate rows from the combined result, and UNION ALL keeps every row for better performance.
A left join keeps every row from the left table and fills the right hand columns with null when nothing matches.
A primary key is a column or set of columns whose values identify each row uniquely and can never be null.
Null means unknown, so comparisons with equals never match. Use IS NULL or IS NOT NULL instead.
It collects rows that share the same values into groups so aggregate functions can be computed per group.
DELETE removes rows one by one and can be filtered, while TRUNCATE empties the whole table much faster.
The reference follows standard SQL, and the examples work in MySQL, PostgreSQL and SQLite with minor changes.
Yes. It is completely free, requires no account and works entirely in your browser with no tracking.

Last updated: October 10, 2026