SQL Recipes Pro

201 SQL queries with explanations, all sections open. Run a query right in the app and see the result table.

A reference of everyday SQL, from a first SELECT to window functions. Every query is written out in full and explained.

• 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: most queries execute against a live practice database and the result table appears under the query. Needs an internet connection; the practice database allows 80 queries a day. • Dialects side by side: MySQL, PostgreSQL, SQLite, MS SQL Server, Oracle, Firebird, Access. Where they differ, each one is shown separately. • The practice database is the classic world dataset: 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 are kept in the app and always at hand. • Search by section name or by a fragment of a query. • Everything except running works offline: queries, search, favourites. No account needed. • Light and dark themes, font and size, line numbers, soft wrapping.

Every query example is drawn from trusted sources and thoroughly tested.

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