This was one of those where my original solution was much more "sophisticated".
"When solving a problem look for a solution as simple as possible but no simpler" (paraphrasing Einstein).
...
At 08:44 PM 11/1/2005, you wrote:
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.
>
>
>
Dennis Fleming
IISCO
Phone: 570 775-7593
Mobile: 570 351-5290
