SQLite Playground
Run SQLite queries directly in your browser. Create tables, insert data, and query results with a full in-browser SQLite database powered by WebAssembly. 100% client-side, nothing sent to any server.
Loading SQLite engine...
SQLite Quick Reference
| Operation | Syntax | Example |
|---|---|---|
| Create Table | CREATE TABLE name (cols) | CREATE TABLE users (id INTEGER PRIMARY KEY, name TEXT) |
| Insert | INSERT INTO t VALUES (...) | INSERT INTO users VALUES (1, 'Alice') |
| Select | SELECT cols FROM t WHERE ... | SELECT name FROM users WHERE age > 25 |
| Join | SELECT ... FROM a JOIN b ON ... | SELECT * FROM orders JOIN users ON orders.user_id = users.id |
| Aggregate | SELECT agg(col) GROUP BY col | SELECT dept, COUNT(*) FROM emp GROUP BY dept |
| CTE | WITH name AS (...) SELECT ... | WITH active AS (SELECT * FROM users WHERE active=1) SELECT * FROM active |
| Window | func() OVER (PARTITION BY ...) | SELECT name, ROW_NUMBER() OVER (ORDER BY age) FROM users |
| JSON | json_extract(col, path) | SELECT json_extract(data, '$.name') FROM docs |