Need script to identify duplicate rows
hi,
There are hundreds of records in my document which I have stored in a tabular form. I want to find the number of duplicate rows that exists in my long table and then remove them. Can anybody provide me the script to identify the duplicate rows from the table. How can I do this ?
Re: Need script to identify duplicate rows
If you want to delete the duplicate rows from the SQL table, follow the microsoft link below. This article provides all the necessary methods to identify and delete duplicate records from the SQL table.
http://support.microsoft.com/kb/139444
Re: Need script to identify duplicate rows
Re: Need script to identify duplicate rows
This is Renu. I want the following books
1)Puzzles to puzzle you - Shakuntala Devi
2)More puzzles - Shakuntala devi
3)Brain Teasers - George Summers
4)aptitude - R. S. Agarwal
hey guyz, if u have these books, dont forget to post ........
Re: Need script to identify duplicate rows
Here you go for the first one Have it from the following attachment :