MariaDB playground

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

MariaDB is an open source relational database system, made by the original developers of MySQL.

⛫ homepage • αω tutorial • ⚘ community

Sandbox details

MariaDB version:    11.3
sandbox engine:     codapi
sandbox name:       mariadb
allowed commands:   run
in-browser:         ✘

Usage example:

select 'Hello, World!' as message;

<codapi-snippet sandbox="mariadb" editor="basic">