T617, “FIRST_VALUE and LAST_VALUE functions”

1. aNo explicit respect nulls clause
2. bNon-standard alternative: first_value(<expr> ignore nulls)
3. cNon-standard alternative: first_value(<expr>, 'ignore nulls')
4. dNon-standard alternative: last_value(<expr> ignore nulls)
5. eNon-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

You can’t catch up on 20 years of SQL evolution in one day. Subscribe the newsletter via E-Mail, Bluesky or RSS to gradually catch up and to keep modern-⁠sql.com on your radar.

About the Author

Markus Winand provides insights into SQL and shows how different systems support it at modern-sql.com. Previously he made use-the-index-luke.com, which is still actively maintained. Markus can be hired as trainer, speaker and consultant via winand.at.

Buy the Book

The essence of SQL tuning in 200 pages

Buy now!
(paperback and/or PDF)

Paperback also available at Amazon.com.

Hire Markus

Markus offers SQL training and consulting for developers working at companies of all sizes.
Learn more »