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.
|
Anil Singh is an author, tech blogger, and software programmer. Book writing, tech blogging is something do extra and Anil love doing it. For more detail, kindly refer to this link..
|
