ORACLE 특정필드값을 우선순위

SELECT
notice_id, sect_id, title, content, title_tag,
url, file_name, read_cnt, reg_dt, category
FROM TUSR_NOTICE
ORDER BY DECODE(notice_id, '299', 1), reg_dt DESC

SELECT * FROM kinquiz
ORDER BY DECODE(
CASE
WHEN (SYSDATE >= start_dt AND SYSDATE <= end_dt) THEN 1
END, 1, 1
), quiz_no DESC

강신윤의 홈피에서 퍼왔어요.