sql排名语句

查询全部

select dwmc,pjdf,row_number() over(order by pjdf desc) as paiming from Sab_hhb_zhb inner join jgdx on jgdx.mid=Sab_hhb_zhb.mid
查询单个
select paiming from (select mid,pjdf,row_number() over(order by pjdf desc) as paiming from Sab_hhb_zhb ) Sab_hhb_zhb where Sab_hhb_zhb.mid='zys0519645'