select p.*,p.rn from
(select id , row_number() over (order by apply_date desc) rn from t_company_apply where company_no='37020000000003001' ) p
(select id , row_number() over (order by apply_date desc) rn from t_company_apply where company_no='37020000000003001' ) p
where p.id='ae2e829ecffd4715a5c163f829c2e0f5'
利用row_number() over (order by apply_date desc) rn实现,注意from子句的排序写法