Hi,
How can I check all duplicated rows out from a large table?
The values are not keys so they may have more than one occurrence.
Thanks for your help.
Regards, CHAN
Try something like:
select count(*) num, colvalue from table1 group by colvalue having num > 1
If you want to check for duplicates among multiple columns, then try:
select count(*) num, colvalue1, colvalue2, colvalue3 from table1 group by colvalue1, colvalue2, colvalue3 ... having num > 1
Mike
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
