select * from NEW_CMD_DETILE order by (case when flag = '是' then 1 else 2 end) , time desc
select * from NEW_CMD_DETILE order by flag,time;
SQL> select ascii('是') from dual;ASCII('是') ----------- 51911SQL> select ascii('否') from dual;ASCII('否') ----------- 47089 --否 的ascii码比 是 小 所以用desc select * from NEW_CMD_DETILE order by flag desc,time
SELECT flag,TIME FROM ( SELECT flag,TIME,Decode(flag,'是',0,1) rn FROM NEW_CMD_DETILE ) ORDER BY rn asc,time desc
select * from NEW_CMD_DETILE order by decode(flag,'是',1,2),time;
SQL> select ascii('是') from dual;ASCII('是')
-----------
51911SQL> select ascii('否') from dual;ASCII('否')
-----------
47089
--否 的ascii码比 是 小 所以用desc
select * from NEW_CMD_DETILE order by flag desc,time
SELECT flag,TIME FROM (
SELECT flag,TIME,Decode(flag,'是',0,1) rn FROM NEW_CMD_DETILE
)
ORDER BY rn asc,time desc
select * from NEW_CMD_DETILE order by decode(flag,'是',1,2),time;