案例:利用 DECODE 函数,让 common = 1 的数据排在最前面
select
ID, NAME, FILE_NAME, URL, CONTENT, DEL_FLAG, COMMON
from PRINTING
where DEL_FLAG = 0
ORDER BY DECODE(COMMON, 1, 0), ID ASC
结合分页,排序示例:
select
x.*
from
(select
ID, NAME, FILE_NAME, URL, CONTENT, DEL_FLAG, COMMON
from PRINTING
where DEL_FLAG = 0
ORDER BY DECODE(COMMON, 1, 0), ID ASC) x
where
rownum between 0 and 9