Deleting duplicate rows in SQL

• Use the DISTINCT keyword in SELECT statement to retrieve unique rows

• Use GROUP BY clause to group rows with same values and then use aggregate functions to select one row

• U...read more

With CTE as(

Select count(*),id,name from table

group by id,name

having count(*)>1)

delete from cte

WITH cte AS (

SELECT

field1,filed2

ROW_NUMBER() OVER (PARTITION BY field1,filed2

ORDER BY field1,filed2) row_num

FROM TABLE_NAME

)

DELETE FROM cte

WHERE row_num > 1;

Having count(*)>1; by using this query