deleting the duplicate records from SQL Server table

Karthika Palaniswamy

17y8.5k2025Blog

To delete the duplicate records(same records in one more time) from SQL Server Data base table,use this query.

2 Comments

Join the conversation! Your thoughts help the community grow.

Karthika Palaniswamy17y ago
<link rel="File-List" href="file:///C:%5CUsers%5CNalini%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_filelist.xml"><link rel="themeData" href="file:///C:%5CUsers%5CNalini%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_themedata.thmx"><link rel="colorSchemeMapping" href="file:///C:%5CUsers%5CNalini%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_colorschememapping.xml"> <o:p> </o:p> Hi,<o:p></o:p> <o:p> </o:p> Maggogg,<o:p></o:p> <o:p> </o:p> Yap Sure............<o:p></o:p> <o:p> </o:p> First i set my table ROWCOUNT = 1 and i have check the conditions > 1 why? because... If more then one records with the same Parameter value are stored in the same table, This condition will check and delete that duplicate value. Without set ROWCOUNT = 1, how our Condition will identify the rows and their datas more then one times? thats why.<o:p></o:p> <o:p> </o:p> then...<o:p></o:p> <o:p> </o:p> COUNT(*) .. the condition must check each and every rows and coloums, unless we can not get exact dup licate records.. thats why i used COUNT(*). Example: one more User's Name, City, Occupation, Pincode, etc.. etc.. may be same.....<o:p></o:p> <o:p> </o:p> Regards, <o:p></o:p> Karthika Palaniswamy.<o:p></o:p> <link rel="File-List" href="file:///C:%5CUsers%5CNalini%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_filelist.xml"><link rel="themeData" href="file:///C:%5CUsers%5CNalini%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_themedata.thmx"><link rel="colorSchemeMapping" href="file:///C:%5CUsers%5CNalini%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_colorschememapping.xml"> <o:p></o:p>
naura pax17y ago
Hi, Can you explain why do we need to set rowcount to 1? if we don't do that won't delete all records in the first query itself? That's how i'm thinking right now i'm not sure but if you can explain that why we need iteration and check count(*) each time, or how you arrived at this solution. Thanks in advance