查询重复记录的SQL语句

SELECT  id, name FROM  tableName  WHERE  name IN  ( SELECT  name FROM  tableName  GROUP   BY  name HAVING  ( COUNT (name )  >   1 ))  ORDER   BY  name

参考：http://blog.csdn.net/AppleBBS/archive/2010/03/08/5355755.aspx