SQL server exams - Query for duplicate records

Author

Query for duplicate records

vime

2001-11-15, 9:01 am

I have 8000 rows of data. They are some duplicate rows but do not know the SQL statement to find out the duplicates(about 250).

Any ideas

Thanks

colinbun

2001-11-22, 9:17 am

There are a few ways to do this, the easiest depends on the number of fields in the table. One way, if you have 2 fields, is -

select fieldA,fieldB,count(*) from table group by fieldA,fieldB having count(*) > 1

Hope this helps,
Colin

Sponsored Links