查询重复记录的SQL语句
SELECT tagid, tagname FROM uchome_mtag WHERE tagname IN (SELECT tagname FROM uchome_mtag GROUP BY tagname HAVING (COUNT(tagname) > 1)) ORDER BY tagname
posted on 2010-03-08 11:34 ξσ Dicky σξ 阅读(494) 评论(0) 编辑 收藏 举报
posted on 2010-03-08 11:34 ξσ Dicky σξ 阅读(494) 评论(0) 编辑 收藏 举报