SQL Recipes

An everyday SQL reference, from your first SELECT to window functions. Every query comes with an explanation, and most of them run.

• 39 sections: filtering, sorting, calculated fields, functions, GROUP BY, window functions, subqueries, JOIN, UNION, INSERT and UPDATE, data types, tables, views.
• Run in the app: more than half of the queries execute against a live practice database, and the result table appears below the query. Needs an internet connection.
• Changes in new versions: 7 sections from SQL-92 to SQL:2023, showing what each standard added, with the old and the new query side by side.
• Dialects compared: MySQL, PostgreSQL, SQLite, MS SQL Server, Oracle, Firebird, Access. Where they differ, each one is shown separately.
• The practice database is the classic MySQL world sample database: countries, cities, languages. The tables are described in the app.
• Edit any query and run it again; one tap brings the original back.
• Add your own queries; they stay in the app and are always at hand.
• Search by section name or by a fragment of a query.
• Everything except running works offline. No account needed.

WHAT THE FREE VERSION INCLUDES
12 runs and 12 edits a day; the limit resets every morning. The keyword reference is unlocked, with no limits. Up to 5 queries of your own.

The full version unlocks every section, lifts the daily limits and raises the run limit to 80 a day. One purchase, no subscription.

Built by a developer for developers. In active development since 2015.