Dennis, The COUNT (*) items are redundant. Just do:
SELECT eq_nbr, em_nbr, thirdcol, fourthcol, fifthcol, COUNT (*) + FROM whist + GROUP BY eq_nbr, em_nbr, thirdcol, fourthcol, fifthcol + HAVING COUNT (*) > 1 Bill Dennis Fleming wrote: > SELECT eq_nbr COUNT(*), em_nbr COUNT(*) .... FROM whist GROUP BY eq_nbr, > em_nbr, ... HAVING COUNT(eq_nbr) > 1 AND COUNT(em_nbr) > 1 .... > > > > This seems to work but just checking with the SQL mavens > > And then delete duplicate rows using col1, col2, etc. > > >
