HeavenTang

导航

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

posted on 2025-12-29 14:36  HeavenTang  阅读(0)  评论(0)    收藏  举报