if with multiple values (TSQL)

Question

I'm newbie in SQL and i don't understand how this language work I have a code:

if (select Zarobki from PRACOWNICY) < 3000
    update PRACOWNICY set Zarobki = Zarobki * 2
else
    update PRACOWNICY set Zarobki = Zarobki / 2

How I can compare multiple values form table? I think select work like loop statements

Just curious what kind of logic is it? If someone earns let's say 2000 then after update will get 4000, and person that has 5000 will get 2500. — Lukasz Szozda
– Lukasz Szozda, Commented Jan 27, 2019 at 11:59

iminiki · Accepted Answer · 2019-01-27 09:49:40Z

5

You can write:

update PRACOWNICY
set Zarobki = CASE
               when Zarobki < 3000
                then Zarobki * 2
               else
                then Zarobki / 2
              END

answered Jan 27, 2019 at 9:49

iminiki

2,57112 gold badges40 silver badges47 bronze badges

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

Comments

Derviş Kayımbaşıoğlu · Accepted Answer · 2019-01-27 09:55:03Z

1

this kind of operation can be done with one query.

update PRACOWNICY 
set Zarobki = 
  case when Zarobki < 3000 then 
    Zarobki * 2 
  else 
    zarobki /2 
  end

This query is equivalent to

update PRACOWNICY set Zarobki = Zarobki * 2
where Zarobki < 3000;

update PRACOWNICY set Zarobki = Zarobki / 2
where Zarobki >= 3000;

edited Jan 27, 2019 at 9:55

answered Jan 27, 2019 at 9:49

Derviş Kayımbaşıoğlu

30.9k4 gold badges55 silver badges79 bronze badges

2 Comments

Derviş Kayımbaşıoğlu Over a year ago

yes because your example code has else statement :) what do you want to do? please update your question and provide sample data and expected output so that we can understand what you are up to

Magician Artemka Over a year ago

I modify your code and it work. Just change 'else' on second 'when -than'

Collectives™ on Stack Overflow

if with multiple values (TSQL)

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related