--排名SQL
select row_number() over(order by usergold desc) as seq,* from (select top 10 * from tb_user_inst order by usergold desc)
as temp
select row_number() over(order by usergold desc) as seq,* from (select top 10 * from tb_user_inst order by usergold desc)
as temp