Delete duplicate rows in SQL Server

Delete duplicate rows in SQL Server

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])


For more detail, you can go below links.


ANIL SINGH

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..

My Tech Blog - https://www.code-sample.com/
My Books - Book 1 and Book 2

www.code-sample.com/. Powered by Blogger.
^