17,377
社区成员
发帖
与我相关
我的任务
分享
--排序1: 如何按今天,然后时间排序。
select orderno,dtime
from(select orderno,dtime,case when dtime=trunc(sysdate) then 0 else 1 end flag
from tb
)
order by flag,dtime;
--排序2: 如我按时间+单号就是A002,A001,A003,A001
select orderno,dtime from tb order by dtime,orderno;
--排序3: 如果按单号+时间就是A001,A001,A002,A003
select orderno,dtime from tb order by orderno,dtime;
with tmp as
(
select 'A001' orderid, '17:00' dt from dual union all
select 'A002' orderid, '07:00' dt from dual union all
select 'A001' orderid, '08:00' dt from dual union all
select 'A003' orderid, '09:00' dt from dual
)
select *
from tmp
order by dbms_random.value;