Window Function

Compute values across a set of rows

Advanced

SQL

SELECT name, salary,
  RANK() OVER (ORDER BY salary DESC) as rank
FROM employees;

What each clause does

RANK() OVER (ORDER BY salary DESC) assigns a rank to each row based on salary, without collapsing rows like GROUP BY.

Related tools

SQL Formatter SQL Syntax Cheatsheet

Other SQL examples

SELECT All Rows SELECT with WHERE INSERT INTO UPDATE SET DELETE FROM INNER JOIN LEFT JOIN GROUP BY ORDER BY Subquery CREATE TABLE Common Table Expression (CTE)UPSERT (ON CONFLICT)LIMIT & OFFSET