To delete duplicate rows from a table, use the DISTINCT keyword or GROUP BY clause.

• Use the DISTINCT keyword to select unique rows from the table.

• Use the GROUP BY clause to group the rows by a specific...read more