Re: newbie question, unique index || double entries
From: Michael Nolan <nolan_at_helios.unl.edu>
Date: 26 Aug 1993 14:58:04 GMT
Message-ID: <25ij1s$4pv_at_crcnis1.unl.edu>
Date: 26 Aug 1993 14:58:04 GMT
Message-ID: <25ij1s$4pv_at_crcnis1.unl.edu>
nussbaumer_at_130.92.4.10 (Marc Nussbaumer) writes:
>SELECT COUNT(UNIQUE(NO1||'.'||NO2))
>FROM ...
>WHERE ...
>My question is, how do I spot the double entry?
SELECT NO1, NO2, COUNT(*) FROM TABLENAME GROUP BY NO1, NO2 HAVING COUNT(*) > 1;
--- Michael Nolan, Sysop for the DBMS RoundTable on GEnie nolan_at_notes.tssi.com, dbms_at_genie.geis.com (posted from nolan_at_helios.unl.edu)Received on Thu Aug 26 1993 - 16:58:04 CEST