T617, “FIRST_VALUE and LAST_VALUE functions”

1. No explicit respect nulls clause
2. Non-standard alternative: first_value(<expr> ignore nulls)
3. Non-standard alternative: first_value(<expr>, 'ignore nulls')
4. Non-standard alternative: last_value(<expr> ignore nulls)
5. Non-standard alternative: last_value(<expr>, 'ignore nulls')

Related

• T611, “Elementary OLAP operations”

• T612, “Advanced OLAP operations”

• T614, “NTILE function”

Normative References

T617, “FIRST_VALUE and LAST_VALUE functions” is defined as optional feature in ISO/IEC 9075-2:2023. It first appeared in SQL:2011.0