sunraajkumar

 Profile Answers by sunraajkumar Questions by sunraajkumar

• Jun 3rd, 2009

 

Example sample query: if then else condition

SELECT 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;

sen_sam86

 Profile Answers by sen_sam86 

• Jun 24th, 2009

 

SELECT  e.emp_name, e.emp_id,
         
           CASE e.emp_id
           WHEN 1133 THEN ' The new name is ' || e.emp_name
           WHEN 1134 THEN ' The new name is ' || e.emp_name
           END AS "New_emp_name"

FROM emp e

hope this will help u,,,!