Case (1) 썸네일형 리스트형 007 - [Oracle PL/SQL] CASE expression & CASE Statement # 비교값이 1개인 경우 select employee_id,first_name,salary,department_id, case department_id when 90 then salary*1.1 when 60 then salary*1.2 when 100 then salary*1.3 else salary END new_sal from employees; ------------------------------------ # 여러개의 조건을 비교 가능 select employee_id,first_name,salary,department_id, case when department_id=90 then salary*1.1 when department_id=60 then salary*1.2 when departme.. 이전 1 다음