Question d’entretien chez Emerson

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?