How to use select statement in Case?

sen_sam86

 Profile Answers by sen_sam86 Questions by sen_sam86

• Jun 24th, 2009

SELECT  e.emp_name, e.emp_id,                      CASE e.emp_id       ...

sunraajkumar

 Profile Answers by sunraajkumar Questions by sunraajkumar

• Jun 3rd, 2009

Example sample query: if then else conditionSELECT empno, ename,
job, sal,
CASE job WHEN 'manager' THEN sal *0.10
WHEN 'analyst' THEN sal *0.20
WHEN 'president' THEN sal *0.30
ELSE sal END "Revised Salary" from emp;

Answer Question  Select Best Answer