怎样选出文章数最多的作者？

[hgllucky]

怎样选出文章数最多的作者？
表zjwz，字段author代表作者名字

[xutao888]

select author,count(articleid) as comm from zjwz group by author order by comm desc

[meizz]

SQL语句group by + order by

[xxuu503]

select top1 author from zjwz group by author order by count(articleid) desc

[tokilcoom]

mark

[Amely]

select top 1 author,count(articleid) as comm from zjwz group by author order by comm desc

[sujinlin]

SELECT TOP 1 COUNT(author) AS authorNum, author
FROM zjwz
GROUP BY author
ORDER BY COUNT(author) DESC

[hy98521]

select count(id) from table where user='author'