Using FIRST_VALUE with different data types
Performance considerations when using FIRST_VALUE
Limitations of the FIRST_VALUE function in SQL
Using FIRST_VALUE in subqueries
Performing calculations on the first value using FIRST_VALUE