Using FIRST_VALUE to find the first occurrence of a billing address in a dataset
Using FIRST_VALUE to find the first occurrence of a shipping address in a dataset
Using FIRST_VALUE to find the first occurrence of an invoice number in a dataset
Using FIRST_VALUE to find the first occurrence of a transaction ID in a dataset
Using FIRST_VALUE to find the first occurrence of a salesperson ID in a dataset