newbie question, unique index || double entries

From: Marc Nussbaumer <nussbaumer_at_130.92.4.10>
Date: Thu, 26 Aug 1993 11:02 GMT
Message-ID: <19930826110203.nussbaumer_at_fennec.unibe.ch>


Hi,
I would like to create a unique index on two numerical fields in a table which has about 20'000 records.
I did a
SELECT COUNT(NO1||'.'||NO2)
FROM ...
WHERE ...
and a
SELECT COUNT(UNIQUE(NO1||'.'||NO2))

FROM ...
WHERE ...
Now the first SELECT reports 20'000
and the second reports 19'999
which means that I have _one_ DOUBLE ENTRY and my Index won't work! My question is, how do I spot the double entry? BIG thanks for your answer
Ma


    Marc A. Nussbaumer, Ph.D., Natural History Museum, Bernastrasse 15     CH-3005 Bern, Switzerland, Phone +41 (0)31 482290, FAX +41 31 482499

                       nussbaumer_at_nmbe.unibe.ch                                

-----------------------------------------------------------------------------
Received on Thu Aug 26 1993 - 13:02:00 CEST

Original text of this message