可以使用来执行条件订单
CASE,如下所示:
select * from testorder by flag , case when flag then date end desc , case when not flag then date end asc

可以使用来执行条件订单
CASE,如下所示:
select * from testorder by flag , case when flag then date end desc , case when not flag then date end asc