Need script to identify duplicate rows

[Dwij]

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 ?

[MindSpace]

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

[Modifier]

Go through the following threads -

Delete duplicate rows using Macros

Delete duplicate tuples from a table in SQL Server

How to Remove Duplicate Entries from Table ?

[Renu Singla]

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

[Praetor]

Here you go for the first one Have it from the following attachment :