colin.sql

Using FIRST_VALUE to find the first non-zero value in a dataset

Using FIRST_VALUE to calculate cumulative totals

Handling NULL values with FIRST_VALUE

Grouping the data with FIRST_VALUE based on certain criteria

Calculating the ranking of first values using FIRST_VALUE

 previous next 