比如统计某个表中,姓名出现的次数: select xingming,count(*) from biao group by xingming having count(*) > 2 要有group by 就可以!