oracle指定日期最近的数据查询
select * from( Select* from CXSJ_DNOLD_4_404_1
where LOU='四号楼' and FJ='404-1' AND LU='A'
Orderby 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
页:
[1]