sql语句找出这样重复的记录

Select   *   from   tblName   where   a   IN       (Select   a   from   tblName   Group   by   a   having   count(a)>1)   Order   by   a



Select   *   from   tblName   where   a   IN       (Select   a   from   tblName   Group   by   a   having   count(a)>1)   Order   by   a
原文地址:https://www.cnblogs.com/chengulv/p/579211.html