SQLite playground

select
  dense_rank() over w as rank,
  first_name, department.name as dep_name,
  salary
from employee
  join department using(dep_id)
window w as (order by salary desc)
order by rank, emp_id;

This playground is completely in-browser.

The first run will download the SQLite runtime (2.1 MB), so it may take some time. Subsequent runs will be instantaneous.

SQLite is a library that implements a small, fast, self-contained, high-reliability, full-featured, SQL database engine. SQLite is the most used database engine in the world.

⛫ homepage • αω tutorial • ⚘ community

Sandbox details

SQLite version:     3.44
sandbox engine:     wasi
sandbox name:       sqlite
allowed commands:   run
in-browser:         ✔

Usage example:

```sql
select 'Hello, World!' as message;
```

<codapi-snippet engine="wasi" sandbox="sqlite" editor="basic">
</codapi-snippet>

Documentation