SQL/MX 3.1 Reference Manual (H06.23+, J06.12+)

SQL/MX Functions and Expressions
HP NonStop SQL/MX Release 3.1 Reference Manual—663850-001
9-19
Examples of CASE
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.