对一张表table搜索重复的A字段

http://topic.csdn.net/t/20030313/09/1524374.html

select   *   from   table   group   by   a   having   count(a)> 1

select   a   from   table   group   by   a   having   count(1)> 1