first_value(…) ignore nulls

1. Non-standard alternative: first_value(<expr> ignore nulls)
2. Non-standard alternative: first_value(<expr>, 'ignore nulls')

The first_value(…) window function with the ignore nulls clause evaluates its argument in the rows defined by the over clause in order and returns the first non-null value (if any).

SELECT FIRST_VALUE(<expr>) IGNORE NULLS OVER (ORDER BY …)
  FROM …

Related

• Options: first_value(…) [respect nulls]

• last_value(…) [respect nulls]

Normative References

The first_value() ignore nulls is defined in ISO/IEC 9075-2:2023 as part of optional feature T617, “FIRST_VALUE and LAST_VALUE functions”.