first_value, last_value

BigQueryDb2 (LUW)DuckDBH2MariaDBMySQLOracle DBPostgreSQLSQL ServerSQLite200720092011201320152017201920212023⚠ 3.25.0 - 3.51.0a⊘ 3.5.7 - 3.23.1✓ 2022 - 2025a⚠ 2012 - 2019a⊘ 2008R2⚠ 8.4 - 18a⊘ 8.3✓ 11gR2 - 23.26.0a⚠ 11gR1a⚠ 8.0.11 - 9.5.0a⊘ 5.0 - 5.7⚠ 10.2 - 12.1.2a⊘ 5.1 - 10.1✓ 1.4.198 - 2.4.240⊘ 1.4.191 - 1.4.197⚠ 1.0.0 - 1.4.0c⚠ 9.7 - 12.1.2b⚠ 2.0c
  1. No ignore nulls
  2. Proprietary nulls treatment: first_value(<expr>, 1, null, 'IGNORE NULLS') (it’s a string argument)
  3. Proprietary nulls treatment: first_value(<expr> IGNORE NULLS) (no comma)