Remove Duplicate Records | Dataford Interview Questions

Write an SQL query to remove duplicate records.

Return the deduplicated records based on the business columns, excluding the surrogate record identifier. The result should contain each unique combination only once.

Output

One row per unique combination of customer_email, full_name, and department
Columns: customer_email, full_name, department
Sort by customer_email, then full_name, then department in ascending order, with NULL values last

Schema

employee_directory

Column	Type	Description
record_idPK	INT	Unique identifier for the stored record
customer_email	VARCHAR(255)	Business email associated with the record
full_name	VARCHAR(150)	Full name associated with the record
department	VARCHAR(100)	Department associated with the record

Your question is Remove Duplicate Records. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem