Re: duplicates
From: John Jones <john_at_iluvatar.tip.duke.edu>
Date: 1995/08/01
Message-ID: <Pine.NXT.3.90.950801083041.7611A-100000_at_iluvatar>#1/1
Date: 1995/08/01
Message-ID: <Pine.NXT.3.90.950801083041.7611A-100000_at_iluvatar>#1/1
try select empno from emp having count(empno) > 1 group by empno. This should give you everything that has a count greater than 1.
John Jones | my views are my own......... Oracle Consultant | no matter what company they are john_at_iluvatar.tip.duke.edu | coming from.Received on Tue Aug 01 1995 - 00:00:00 CEST
--------------------------------------------------------------------