Viewing 3 posts - 1 through 3 (of 3 total)
SELECT DISTINCT * from tableName
While this gives you a list of records without the duplicates, it does not help much in deleting the duplicates. Additional code is still need to...
October 8, 2008 at 1:23 am
I am sure the code works fine, however the article implied that this is one situation where you have to use cursors - which are very inefficient if you can...
October 6, 2008 at 1:42 am
I think this is a much more efficient example for deleting duplicate rows using a single query and not having to resort to using Cursors:
http://dipakjpatel.blogspot.com/2007/08/delete-duplicate-rows-using-single.html
Regards
Nick
October 3, 2008 at 1:19 am
Viewing 3 posts - 1 through 3 (of 3 total)