Emerson Interview Question

How would you use SQL to identify and remove duplicate rows from a table based on a specific column, keeping only the first occurrence of each unique value?