如何统计一行中的某字段数据出现最多的几次

[sky_2008]

如table表a字段

a
1
2
3
3
6
1
1
1

我想得到出现最多的几次值

[ralpha08]

select top 1 * from table group by a order by a desc

[ralpha08]

select top 1 count(*) from table group by a order by a desc