finding duplicate records

[divinyl]

Hi all,

I would like to create a composite key on a table in a database that already has loads of records. It is not letting me because there are duplicate records in the database, and i need to be able to identify these duplicates and delete them. What kind of query can i write that will group all duplicate records for meso i can then delete them?

Any assistance much appreciated.

Divinyl

 

[swampBoogie]

http://www.tek-tips.com/faqs.cfm?spid=183&sfid=2682

 

[HFA]

select id,sum(salaries)
from tbl
having count(id)>=2
group by id

 

[divinyl]

thanks to both of you who replied- both of these worked well.

Divinyl