ORACLE SQL查询倒数第二条

-- 查询倒数第二条
select * from (select row_number() over(order by pay_no desc) rn, t.* from tm_pm_pay t where hospital_code = '0002') where rn = 2

 

posted @ 2022-09-28 10:02  一隅桥畔  阅读(794)  评论(0)    收藏  举报