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:
der by and see the counts of all of them (I
added an order by so that the ones with 1 show up first) 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, Octob
TECTED]
Sent: Tuesday, 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
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 uni
