RANK()
MariaDB
MySQL
Oracle DB
PostgreSQL
SQL Server
2007
2009
2011
2013
2015
2017
2019
2021
⊘ 2008R2 - 2022
✓ 15+
⚠ 19c - 21c
a
⊘ 11gR1 - 18c
Only with
where
clause:
OVER(ORDER BY…)
+
WHERE x=?