Hank <[EMAIL PROTECTED]> writes: >How do I find which record is duplicated (without doing the typical >self-join query)? This table has 70 million rows, so that's not >really feasible.
select col, count(1) cnt from tab group by col having cnt > 1;
This will print out all duplicated col rows.
Brad Eacker ([EMAIL PROTECTED])
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
