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
-- 查询倒数第二条 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