Neoview SQL Reference Manual (R2.5)

WHEN 500 THEN 'ACCOUNTANT'
WHEN 600 THEN 'ADMINISTRATOR ANALYST'
WHEN 900 THEN 'SECRETARY'
ELSE NULL
END
FROM persnl.employee;
LAST_NAME FIRST_NAME (EXPR)
-------------------- --------------- -----------------
GREEN ROGER MANAGER
HOWARD JERRY MANAGER
RAYMOND JANE MANAGER
...
CHOU JOHN SECRETARY
CONRAD MANFRED PROGRAMMER
HERMAN JIM SALESREP
CLARK LARRY ACCOUNTANT
HALL KATHRYN SYSTEM ANALYST
...
--- 62 row(s) selected.
• Use a searched CASE to return LAST_NAME, FIRST_NAME and a value based on SALARY
that depends on the value of DEPTNUM:
SELECT last_name, first_name, deptnum,
CASE
WHEN deptnum = 9000 THEN salary * 1.10
WHEN deptnum = 1000 THEN salary * 1.12
ELSE salary
END
FROM persnl.employee;
LAST_NAME FIRST_NAME DEPTNUM (EXPR)
---------------- ------------ ------- -------------------
GREEN ROGER 9000 193050.0000
HOWARD JERRY 1000 153440.1120
RAYMOND JANE 3000 136000.0000
...
--- 62 row(s) selected.
356 SQL Functions and Expressions