Searched CASE Expression Example

SQL> select ename, job
2 , case when job = 'TRAINER' then ' 10%'
3 when job = 'MANAGER' then ' 20%'
4 when ename = 'SMITH' then ' 30%'
5 else ' 0%'
6 end as raise
7 from employees
8 order by raise desc, ename;
ENAME JOB RAISE
-------- -------- -----
BLAKE MANAGER 20%
CLARK MANAGER 20%
JONES MANAGER 20%
ADAMS TRAINER 10%
FORD TRAINER 10%
SCOTT TRAINER 10%
SMITH TRAINER 10%
ALLEN SALESREP 0%
JONES ADMIN 0%
KING DIRECTOR 0%
MARTIN SALESREP 0%
MILLER ADMIN 0%
TURNER SALESREP 0%
WARD SALESREP 0%
14 rows selected.
SQL>