Using FIRST_VALUE in window functions
Combining FIRST_VALUE with other SQL functions
Using FIRST_VALUE to find the oldest record in a dataset
Using FIRST_VALUE to find the most recent order in a dataset
Using FIRST_VALUE to find the highest salary in a dataset