Using FIRST_VALUE to find the first occurrence of a customer ID in a dataset
Using FIRST_VALUE to find the first occurrence of a product code in a dataset
Using FIRST_VALUE to find the first occurrence of a credit card number in a dataset
Using FIRST_VALUE to find the first occurrence of a social security number in a dataset
Using FIRST_VALUE to find the first occurrence of a ZIP code in a dataset