求一条SQL语句

[idealabc]

SELECT count( * ) AS ct, userid FROM `fookoo_hitaction` GROUP BY userid

这是一条分统计每个用户点击数的语句，求大侠帮我改改，我要点击最多的前3个用户

表结构
userid //用户只要点一下，我就插入一次
1
1
1
2
2
3
4
3

[chuifengde]

declare @a table(userid int)
insert @a select 1
insert @a select 1
insert @a select 1
insert @a select 2
insert @a select 2
insert @a select 3
insert @a select 4
insert @a select 3


select top 3 count(1) as ct,userid from @a
group by userid order by ct desc

[idealabc]

谢谢!

[wgzaaa]

SELECT top 3 count(*) AS ct, userid FROM `fookoo_hitaction` GROUP BY userid
order by count(*)

[wgzaaa]

desc