case 문 예제

SELECT *

FROM (

SELECT Row_Number() OVER (ORDER BY A.bbs_seq DESC) AS rownum, 

A.bbs_seq, 

A.bbs_gubun, 

A.bbs_title, 

A.bbs_cont, 

A.bbs_file, 

A.bbs_file_kr, 

A.bbs_insertid, 

CONVERT(CHAR(10), A.bbs_insertdate, 23) as bbs_insertdate,

A.bbs_updateid, 

CONVERT(CHAR(10), A.bbs_updatedate, 23) as bbs_updatedate,

A.bbs_count, 

A.bbs_usechk, 

A.bbs_insertidseq, 

(CASE WHEN bbs_insertidseq=99999999 THEN '관리자' 

      ELSE (select mem_name from MEMBER_NORMAL where                                                                          mem_seq=A.bbs_insertidseq) END) 

       AS mem_name,

  (SELECT count(*) AS bbs_cnt 

  FROM MAIN_BBS_REQUEST AS B WHERE A.bbs_seq = B.bbs_seq   

  ) AS bbs_cnt     

FROM MAIN_BBS AS A(NOLOCK)

WHERE 1=1

SELECT EMPLOYEE_ID, SALARY,

    case 

        WHEN SALARY <= 5000 THEN 'C등급'

        WHEN SALARY > 5000 AND SALARY <= 15000 THEN 'B등급'

        ELSE 'A등급'

   END AS salay_grade     

FROM EMPLOYEES;