Using FIRST_VALUE to find the first occurrence of a job title in a dataset
Using FIRST_VALUE to find the first occurrence of an employee name in a dataset
Using FIRST_VALUE to find the first occurrence of a department name in a dataset
Using FIRST_VALUE to find the first occurrence of a manufacturer name in a dataset
Using FIRST_VALUE to find the first occurrence of a supplier name in a dataset