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
wherep.id='ae2e829ecffd4715a5c163f829c2e0f5'
利用row_number() over (order by apply_date desc) rn实现，注意from子句的排序写法
版权声明：本文为dhklsl原创文章，遵循CC 4.0 BY-SA版权协议，转载请附上原文出处链接和本声明。