Hi,

>what i want the query to return is a list of all the fields in a
>duplicate record plus the count of occurences.

select a, b, c, d, count(*) from t
group by a, b, c, d
having count(*)>1


HTH,

Regards,
Anderson