SQL Recipes vs SQL Play

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. WHAT'S NEW • Improved support for foldable phones and large screens.

Learning and Practicing SQL couldn't be Easier! Presenting you with a beautiful SQL Runner App for all your devices - SQL Play. Say goodbye to installing heavy software like MySQL or Microsoft SQL Server on your computers, just to get SQL running. You don't have to spend hours figuring out what commands to type: - Just to write a simple SELECT query - How to use the WHERE clause - Group data using HAVING clause - What are the data types to be used - And many more Guess what? You don't even need to make your own tables and insert bunch of data by yourself just to test your queries. We already have 10+ inbuilt tables just for you to get your hands dirty with SQL faster than ever. It includes: Albums, Artists, Customers, Employees, Genres, Invoices and more. You get 45+ syntaxes along with their description and easy-to-follow examples in order of their execution, which will guide you firsthand. You don't have to keep scrolling for the commands, you can simply start typing your command and the desired command with syntax will show up. It covers DDL (Data definition language), DML (Data manipulation language) and DQL (Data query language) If you prefer dark mode we have got you covered, SQL Play theme matches your system theme. So that your eyes get the deserved rest. You are not tied to our app with your data, you can export any of your tables into CSV (Comma separated values) using the Export Data feature. Your data goes with you, whether it be Excel, Google Sheets or any other spreadsheet editor or the database of your choice. /// Go down the memory lane Every time you run your query, it gets saved locally in your device which can be accessed by pressing the Up and Down arrow button. You also get auto-complete from history as you type your query, so that you don't have to keep repeating yourself. TLDR; Saves you a lot of time Popular SQL supported databases: • IBM DB2 • MySQL • Oracle DB • PostgreSQL • SQLite • SQL Server • Sybase • OpenEdge SQL • Snowflake