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