数据库查询前十名和当前信息的排名信息

select * From (Select num=Row_number() Over(order By money desc),* From table1) A Where id= '430191'
UNION 
select top 10 * From (Select num=Row_number() Over(order By money desc),* From table1) A 

  

posted @ 2013-05-16 16:41  博宏  阅读(535)  评论(0编辑  收藏  举报