SQL Practice App

Query

[Load sample query] [Another sample query]

TODO/libs

Query

Output

TODO

<< Back to Query

Integer output from commands indicates row(s) affected (like DELETE...FROM). You can run one query at a time to minimize this noise.
Clear last query result
catch errors currently going to console
live table/database view (SHOW DATABASES / SHOW TABLES)
Replace JSON output with key:value tabular output

Using libraries: jquery, jquery mobile, AlaSQL

drop table if exists animals; drop table if exists legs; create table animals(animal STRING, legs INT); insert into animals values ('cat', 4),('dog', 4),('rooster', 2); create table legs(nbr INT); insert into legs values (1),(2),(3),(4); select * from legs l LEFT JOIN animals a ON l.nbr = a.legs ORDER BY l.nbr DESC; -- Select the employee with the second highest salary (Bob); drop table if exists EMP; create table EMP (name string, salary int); insert into EMP values ("Jim", 10000), ("Bob", 20000), ("Joe", 30000); select * from EMP where salary < (select max(salary) from EMP) order by salary DESC LIMIT 1;

Practice SQL (browser or app)