Using FIRST_VALUE to find the first occurrence of a phone number in a dataset
Using FIRST_VALUE to find the first occurrence of an email address in a dataset
Using FIRST_VALUE to find the first occurrence of a foreign key in a dataset
Using FIRST_VALUE to find the first occurrence of a unique identifier in a dataset
Using FIRST_VALUE to find the first occurrence of a NULL value in a dataset