I have a table wherein one column is SUPPOSED to be unique but I
strongly suspect isn't. Because I had this suspicion, I did not apply
a unique index to the column. Assuming there are no null values in
that column how would I find the instances of non-unique values? If I
try to alter table add
, October 21, 2003 12:14 PM
Subject: Find non-unique values
I have a table wherein one column is SUPPOSED to be unique but I
strongly suspect isn't. Because I had this suspicion, I did not apply
a unique index to the column. Assuming there are no null values in
that column how would I
) as follows:
select z, count(*) as numrecords
from duptest
group by z
order by numrecords;
hth,
Dan
-Original Message-
From: Randy Chrismon [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 21, 2003 12:15 PM
To: [EMAIL PROTECTED]
Subject: Find non-unique values
I have a table wherein one
Randy,
For general SQL questions, you might find something in a newsgroup,
such as comp.databases.*, but there are so many peculiarities, even
among the most compliant datbases, that it's hard to really ask a
general question.
As for your unique values...
-Original Message-
From: