Which programming language is this?
SELECT name, ROW_NUMBER() OVER (PARTITION BY dept ORDER BY salary DESC) AS rank FROM employees;
Answer: SQL
Window functions with OVER (PARTITION BY ...) are SQL's ranking construct.
Play Programming Languages ▸
SELECT name, ROW_NUMBER() OVER (PARTITION BY dept ORDER BY salary DESC) AS rank FROM employees;
Answer: SQL