50分求一SQL语句。在线等！

[mfkiqpl]

现有一表：

类型 ：自动编号 文本 文本
字段名：字段0 字段1 字段2
值 ：1 张三 ...
2 李四 ...
3 王二 ...
4 李四 ...
5 张三 ...
6 张三 ...

我要取得 字段1 里出现最多的人名。用什么SQL语句？

[fanruinet]

select top 1 字段1, count(PostUserName) as cnt from table group by 字段1 order by cnt desc

[ShiningstarHu]

select top 1 count(字段1) as 字段1统计, 字段1 from 表 group by 字段 order by 字段1统计 desc

[mfkiqpl]

楼上的再通俗点。。最好用我上面的参数。谢谢

[mrqianliang]

select top 1 字段1,Count(*) as iCount from YourTable group by 字段1 order by iCount desc

[mrqianliang]

这样写更好些：
select top 1 字段1 from (select 字段1,Count(*) as iCount from YourTable group by 字段1) order by iCount desc