请教一个SQL问题？？？

[xiaxuan92021]

要实现SQL SERVER 2000 中对统计数据的排序提取，如：检索出统计结果的前十名，应该怎么处理啊，有相关的函数供调用吗？SQL 语句应该怎么样写呢？谢谢了！！

[yonghengdizhen]

select top 10 from tablename order by totalvalue desc

[pengdali]

select top 10 统计列,sum(数量) 数量 from 表 group by 统计列 order by sum(数量) desc

[愉快的登山者]

select top 10 type, sum(tot) from yourtable
group by type
order by sum(tot) desc