moss_tan_jun

:: :: :: ::

查询重复记录的SQL语句

Posted on 2010-10-10 21:20 moss_tan_jun 阅读(290) 评论(0) 收藏举报

2010-10-09 23:17 by Yoyior Lee, 14 visits, 网摘, 收藏, 编辑

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

刷新页面返回顶部