Hello everyone, I am going to share the T-SQL
query for delete duplicate rows using SQL Server 2012 and you can see the query
detail as below.
T-SQL Query for delete
duplicate rows
WITH mobile AS (
SELECT [Account], [AlertToMobile],
ROW_NUMBER() OVER(PARTITION BY [Account], [AlertToMobile]
ORDER BY
[AlertToMobile])
AS [count]
FROM [dbo].[Mobile]
)
DELETE mobile WHERE [count] > 1
The query result as given below
OR
We have another ways to delete duplicate rows using SQL Server as given below.
DELETE FROM [dbo].[Mobile]
WHERE UID NOT IN(SELECT MAX(UID)
FROM [dbo].[Mobile]
GROUP BY [Account], [AlertToMobile])
GROUP BY [Account], [AlertToMobile])
For more detail, you can go below links.