select ename,job,sal,
(case when sale>4000 then sale*1.1
when sale>3000 then sale*1.2
when sale>2000 then sale*1.3
else sale end) "REVISED_SALE"
from emp;
(case when sale>4000 then sale*1.1
when sale>3000 then sale*1.2
when sale>2000 then sale*1.3
else sale end) "REVISED_SALE"
from emp;
case when sale>4000 then sale*1.1
when sale>3000 then sale*1.2
when sale>2000 then sale*1.3
else sale end "REVISED_SALE"
from emp;