求一个简单语句
怎么查找字段NUMBER里面最大的10个值？请高手指点一下！

[解决办法]
top 10
order by NUMBER
排序取TOP 10
[解决办法]
select top 10 NUMBER from tablename order by NUMBER desc
[解决办法]
楼上正解~~~