$ ./guess_the_languageProgramming Languages
Programming Languages · hard · #514

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 ▸