oracle 按申请时间获取最新的一条数据
select * from (select ktbg.zqsq_id from T_XWGL_LWGL_ZQSQ_V4 ktbg
where ktbg.xs_id= 'S20230201037'
order by abs(to_date(ktbg.sqsj,'yyyy-MM-DD HH24:mi:ss')-sysdate)) where 2> rownum
select * from (select ktbg.zqsq_id from T_XWGL_LWGL_ZQSQ_V4 ktbg
where ktbg.xs_id= 'S20230201037'
order by abs(to_date(ktbg.sqsj,'yyyy-MM-DD HH24:mi:ss')-sysdate)) where 2> rownum