I am looking at a client's data set and I am unable to set an index tag as a primary key because there is a uniqueness violation.

The key is made up of: systemdealnumber+systemaccounttype

Is there a quick SELECT statement I could run that would tell me which records in the table are the duplicates? For some reason I'm drawing a blank on this..

Laterness,
Jon