查询重复记录的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