查询重复记录的SQL语句
时间：2010-10-09 来源：Yoyior Lee
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
相关阅读 更多 +
排行榜 更多 +
