nth_value
BigQuery
Db2 (LUW)
DuckDB
H2
MariaDB
MySQL
Oracle DB
PostgreSQL
SQL Server
SQLite
2008
2010
2012
2014
2016
2018
2020
2022
2024
⚠ 3.25.0 - 3.51.0
a
b
⊘ 3.5.7 - 3.23.1
⊘ 2008R2 - 2025
⚠ 8.4 - 18
a
b
⊘ 8.3
✓ 11gR2 - 23.26.0
⊘ 11gR1
⚠ 8.0.11 - 9.5.0
a
b
⊘ 5.0 - 5.7
⚠ 10.2 - 12.1.2
a
b
⊘ 5.1 - 10.1
✓ 1.4.198 - 2.4.240
⊘ 1.4.191 - 1.4.197
⚠ 1.0.0 - 1.4.0
b
c
✓ 11.1 - 12.1.2
⊘ 9.7 - 10.5
⚠ 2.0
b
c
No
ignore nulls
No
from last
Proprietary nulls treatment:
nth_value(<expr>, <off> IGNORE NULLS)
(no comma)