67,549
社区成员




with tab1 as (
select sysdate - 0.4 dt from dual union all
select sysdate + 0.1 from dual
)
select*from tab1
order by abs(dt - sysdate)
;
with tab1 as (
select sysdate - 0.4 dt from dual union all
select sysdate + 0.1 from dual
)
select*from tab1
order by abs(dt - sysdate)
;
语句没问题,数据类型搞错了吧。