Microsoft SQL Server playground

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

SQL Server is a proprietary relational database system developed by Microsoft.

⛫ homepage • αω tutorial • ⚘ community

Sandbox details

SQL Server version: 2022
sandbox engine:     codapi
sandbox name:       mssql
allowed commands:   run
in-browser:         ✘

Usage example:

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

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

Documentation