[size=medium][size=small]select ename,sal
case when sal<2000 then 'UNDERPAID'
when sal>2000 then 'OVERPAID'
else 'OK'
end as status
from emp; [/size]
[/size]
[size=medium][size=small]select ename,sal
case when sal<2000 then 'UNDERPAID'
when sal>2000 then 'OVERPAID'
else 'OK'
end as status
from emp; [/size]
[/size]