Oracle 让指定数据排在最前面

案例：利用 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