关于查询统计的问题

[rmj0515]

我有个表,里面装的是我发布出去的职位信息，共有800多条,但是里面有相同的职位名称，我现在想统计出有前20为的发布最多的职位名称,比如"教师"这个职位发布了50个，排了第一,"医生"这个职位发布了40个.排第二,以此类推!,sql语句怎么写呢?

[冷箫轻笛]

select top 20 职位名称,count(1) as cou
from tablename
order by cou

[smart_zcg]

select top 20 with ties 职位名称,count(*) as num from tablename group by 职位名称 order by num desc

[yangjianw2004]

select top 20 职位名称,count(*) as count from tablename order by count