how to select records that are not distinct 2

[557]

if i have a table in which the combination of 2 fields are supposed to be unique,

thru an sql, i need to find the records which have these 2 fields with the same value, how can i do this?

 

[swampBoogie]

select c1,c2
from t
group by c1,c2
having count(*) > 1

 

[557]

thanks, i used it