Delete duplicate entry

C# Corner

lejo

3y822SQL Server

i want to keep yellow underlined entry and delete the remaining entries. i mean keep first created entry only ,

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Amit Mohanty3y ago

Try this

;WITH CTE([adv_referenceno], [adv_createdon], [duplicate])
AS (SELECT [adv_referenceno], [adv_createdon], ROW_NUMBER() OVER(PARTITION BY [adv_referenceno] ORDER BY [adv_createdon]) AS [duplicate]
FROM [dbo].[NSP113_Advances])
DELETE FROM CTE WHERE [duplicate] > 1;

For more details check the link

https://www.c-sharpcorner.com/article/different-ways-to-find-and-delete-duplicate-rows-from-a-table-in-sql-server/

Jignesh Kumar3y ago
Hello Lejo,

Please refer this one which will help you out to delete duplicate records,

https://www.c-sharpcorner.com/blogs/delete-duplicate-rows-in-sql

https://www.c-sharpcorner.com/article/different-ways-to-find-and-delete-duplicate-rows-from-a-table-in-sql-server/
Aravind Govindaraj3y ago
You can do with the help of CTE option. please find the link for reference

https://www.c-sharpcorner.com/blogs/delete-duplicate-record-from-sql-data-table-using-cte