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