[SQL] - ORDER BY

ORDER BY 로 쿼리결과를 정렬하려고 할 때, 컬럼값에 따라 우선순위를 정해야 할 경우,

CASE 문을 쓰면 된다.

 

SELECT SUBJECT, ...
  FROM (
  SELECT '컴공' AS SUBJECT, ...
  union
  SELECT '소프트웨어공' AS SUBJECT, ...
  union
  SELECT '전자공' AS SUBJECT, ...
) A
ORDER BY CASE WHEN A.SUBJECT = '컴공' THEN 1
              WHEN A.SUBJECT = '소프트웨어공' THEN 2
              WHEN A.SUBJECT = '전자공' THEN 3
          END ASC