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>