Hi,

This trick uses ROW_NUMBER with a CTE to remove duplicates based on a field:

This removes duplicate references of the field CUSTOMER_ID from the table DATATABLE using the highest (most recent)...