In an old post I see:
SELECT colname COUNT(*) FROM tablename GROUP BY colname HAVING
COUNT(colname) > 1
Which will display rows with the same column value. I want to display rows
where 5 column values determine if the row is duplicated. For example, a
table with 500 rows could have 15 pairs and 10 triplets. The user may want
to view them and then normally click OK to delete 15 of the 15 pairs and 20
of the 10 triplets. Out of those 60 rows you would end up with 25. Hope
that makes sense.
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.
Dennis
*****
Dennis Fleming
IISCO
http://www.TheBestCMMS.com
Phone: 570 775-7593
Mobile: 570 351-5290
