Differences between FIRST_VALUE and LAG function in SQL
Finding the first value occurrence in a dataset using FIRST_VALUE
Using FIRST_VALUE to filter records based on conditions
Using FIRST_VALUE in triggers
Using FIRST_VALUE in user-defined functions