救急：关于select 语句中的问题？

[xhzhang]

我想实现如下功能：

select pap_code,count(*) as num1 from sim_mas where num1 >5 group by pap_code

(pap_code:姓名)
意思是想从一张表中将相同名字大于5次的名字显示出来？

各位大侠帮帮我吧！！！！！

[playyuer]

select pap_code,count(*)
from sim_mas
group by pap_code
having count(*) >5

[playyuer]

select pap_code,count(pap_code)
from sim_mas
group by pap_code
having count(pap_code) >5

[cqq_chen]

又来迟了，可惜啊！

[playyuer]

我也刚来

[zeng_zhh]

select pap_code from sim_mas group by pap_code having count(pap_code)>5