数据库查询前十名和当前信息的排名信息
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
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