DuckDB 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;

DuckDB is an in-process analytical SQL database engine. It is designed to be fast, reliable, portable, and easy to use.

⛫ homepage • αω tutorial • ⚘ community

Sandbox details

DuckDB version:     1.1
sandbox engine:     codapi
sandbox name:       duckdb
allowed commands:   run
in-browser:         ✘

Usage example:

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

<codapi-snippet sandbox="duckdb" editor="basic">
</codapi-snippet>

Documentation