SQL Recipes: Queries, Commands

200+ SQL queries with explanations, 120+ of them free. Tap Run and see the result table right in the app.

An everyday SQL cheat sheet, from your first SELECT to window functions.

• 39 sections, including filtering, sorting, calculated fields, functions, GROUP BY, window functions, subqueries, JOIN, UNION, INSERT and UPDATE, data types, tables, views.
• Changes by standard: 7 sections from SQL-92 to SQL:2023, with before-and-after queries.
• Keyword and function reference: over 180 articles. Browse, search, or tap a word in a query to open its article.
• Dialects compared: MySQL, PostgreSQL, SQLite, SQL Server, Oracle, Firebird, Access. Where they differ, the dialect-specific variants are shown.
• Practice database: the classic MySQL “world” sample (countries, cities, spoken languages); its tables are described in the app.
• Run in the app: more than half of the queries execute against the practice database, and the result table appears directly below the query. Requires an internet connection.
• Search covers the queries themselves, not just titles: type a fragment you remember and find the query.
• Edit queries and rerun the runnable ones; one tap brings the original back.
• Add your own queries; they are saved in the app.
• Everything except running queries works offline. No account needed.

Queries are curated from professional sources and checked before release: the code works and is easy to follow.

FREE VERSION
• 12 runs and 12 edits a day
• Full keyword and function reference; tap a word in a query for up to 12 articles a day
• Up to 5 queries of your own

The full version unlocks every query, removes the limits on edits and on your own queries, and raises the daily run limit to 80. One-time purchase, no subscription.

Built by a developer for developers. The CodePro project has been in active development since 2015.