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:
You can use the group by and having clause:
use test;
drop table if exists duptest;
create table duptest(
x int
, z varchar(25)
) type=innodb;
insert into duptest(x, z) values(1, 'Val1');
insert into duptest(x, z) values(2, 'Val2');
insert into duptest(x, z) values(3, 'Val3');
i
Assuming 'id' is an identifying column and 'dupe_col' is the column with
duplicate values...
SELECT id, COUNT( dupe_col ) AS cnt
FROM tbl
GROUP BY dupe_col
HAVING cnt > 1
HTH
PB
-
- Original Message -
From: Randy Chrismon
To: [EMAIL PROTECTED]
Sent: Tuesday,
