sqlserver2005中有现成的排名函数，而2000中则还没有，用以下方法实现
select balance as balance,(select count(*)+1 from member a where a.balance>b.balance) as rank from member b order by rank asc;
附图：
