Query Lab — Practice every SQL statement

Query Lab

loading databases

Q Query Lab Practice every SQL statement

Not connected ●

Loading...

0 of 0

Clear current draftthis question

Backup Database...live only

Restore Database...live only

Reset all progresseverything

No database selected

Connect to a SQL Server instance to explore your database schema visually.

Query Builder

Drag tables from the Object Explorer to build queries visually.

Source Target

Source only Target only Different

Schema Diff

Select two databases to compare their schemas.

Generated SQL

initializing

draft restored

⌘/Ctrl+⏎ run · ⌘/Ctrl+Q format · ⌘/Ctrl+Space hint — modified

Type: X: Y:

Run a query to see results

No execution plan

Run a query with SET SHOWPLAN_XML ON to view the execution plan.

Run a query with numeric data to see a chart

Streaming results…

No results returned.

easy select Q1 of 1

Loading…

Sandbox

Run anything.

This is your scratchpad. Write any SQL — SELECT, INSERT, CREATE, anything. Multi-statement scripts run in order. Changes are saved automatically and persist between sessions, per database.

Saved snippets 0

Tip. Click Reset DB in the top bar to wipe your changes and restore the seed data. The "modified" badge appears whenever your sandbox database differs from the original.

Multi-statement. Separate statements with ; — they all run. Only the last SELECT result shows in the table; everything else just executes.

MS SQL

Translate SQL.

Write SQLite SQL in the editor, then click Translate to MS SQL to see the equivalent T-SQL. The translation handles syntax differences between SQLite and Microsoft SQL Server.

Translation Output

No translation yet. Write some SQLite SQL and click "Translate to MS SQL".

Note. This translates SQLite syntax to MS SQL Server T-SQL. The output is for reference and migration purposes — it doesn't execute against a real database.

All Questions

Sign In

Username

Password

Don't have an account?

Keyboard Shortcuts

Correct

Nicely done. Onward.