OVER(PARTITION BY x ORDER BY…)
+
WHERE x=?
MariaDB
MySQL
Oracle DB
PostgreSQL
SQL Server
2010
2012
2014
2016
2018
2020
2022
2024
✓ 2017 - 2025
⊘ 2014
✓ 2008R2
✓ 17 - 18
⊘ 15 - 16
⊘ 8.3 - 14
⊘ 11gR1 - 23.26.0
⊘ 5.0 - 9.5.0
⊘ 5.1 - 12.0.2