Conditional Single SQL Query Insert

Question

Let say I have a TABLE called:

 EMP(Eid,Ename,ESalary)

Now I have to write a single query that will update:

if employee's salary >= 20000 then increment 25% else update 15% salary

RichardTheKiwi · Accepted Answer · 2013-04-25 05:12:49Z

3

update EMP
   set ESalary = CASE WHEN salary >= 20000
                      THEN salary * 1.25
                      ELSE salary * 1.15
                      END;

answered Apr 25, 2013 at 5:12

RichardTheKiwi

108k28 gold badges206 silver badges269 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

MD TAHMID HOSSAIN Over a year ago

Thanks Mate. i forgot about case

NoNaMe · Accepted Answer · 2013-04-25 05:24:02Z

0

Try this:

update emp a set esalrary = 
(select (case when esalary >=20000 then esalary+(esalary*25/100) 
else  esalary+(esalary*25/100) end) from emp b where a.eid=b.eid);

edited Apr 25, 2013 at 5:24

NoNaMe

6,29033 gold badges86 silver badges114 bronze badges

answered Apr 25, 2013 at 5:14

Aspirant

2,2789 gold badges31 silver badges44 bronze badges

Collectives™ on Stack Overflow

Conditional Single SQL Query Insert

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related