colin.sql

Using FIRST_VALUE to find the first occurrence of a specific character in a dataset

Using FIRST_VALUE to find the first occurrence of a string in a dataset

Using FIRST_VALUE to prioritize records in a dataset

Using FIRST_VALUE to find the first unique value in a dataset

Differences between FIRST_VALUE and LEAD function in SQL

 previous next 