雅安论坛
标题:
oracle指定日期最近的数据查询
[打印本页]
作者:
匿名
时间:
2021-12-6 18:06
标题:
oracle指定日期最近的数据查询
select * from
( Select * from CXSJ_DNOLD_4_404_1
where LOU='四号楼' and FJ='404-1' AND LU='A'
Order by abs(ENDTIME-to_date('2021-11-01 23:00','YYYY-MM-DD HH24:MI:SS') ) ,JG
) a
where rownum<2
select * from
(
Select * from CXSJ_DNOLD_4_404_1
where LU='A' and FJ='404-1'
Order by abs(ENDTIME-TO_DATE('2021-11-01 23:00','YYYY-MM-DD HH24:MI:SS'))
) a
where rownum=1
复制代码
欢迎光临 雅安论坛 (https://www.yaanbbs.net/)
Powered by Discuz! X3.4