导出重复的数据
mysql> select Acolumn1 from tbA group by Acolumn1 group by Acolunm1 having count( Acolumn1 ) > 1;
导出某列重复的数据
mysql> select * from tbA where Acolumn1 in ( select Acolumn1 from tbA group by Acolunm1 having count( Acolumn1 ) > 1 );
导出重复的数据
mysql> select Acolumn1 from tbA group by Acolumn1 group by Acolunm1 having count( Acolumn1 ) > 1;
导出某列重复的数据
mysql> select * from tbA where Acolumn1 in ( select Acolumn1 from tbA group by Acolunm1 having count( Acolumn1 ) > 1 );