SQL update query with IF ELSE

Question

How do I write the following SQL Query (SSMS)

My Table has 2 columns - ColumnA and ColumnB

IF my_table.columnA < 15
  update my_table set my_table.ColumnB = 0
else IF my_table.columnA < 28
  update my_table set my_table.columnB = 1
else IF my_table.columnA < 43
  update my_table set my_table.columnB = 2
else IF my_table.columnA < 60
  update my_table set my_table.columnB = 3

Thanks for your help!

Tag your question with the database you are using.

Gordon Linoff
– Gordon Linoff

2018-04-23 15:37:02 +00:00
Commented Apr 23, 2018 at 15:37 — Gordon Linoff
– Gordon Linoff, Commented Apr 23, 2018 at 15:37
Possible duplicate of MySQL: Update Query using If else

Mehadi Hassan
– Mehadi Hassan

2018-04-23 15:38:53 +00:00
Commented Apr 23, 2018 at 15:38 — Mehadi Hassan
– Mehadi Hassan, Commented Apr 23, 2018 at 15:38

Gordon Linoff · Accepted Answer · 2018-04-23 15:38:01Z

2

You seem to want a case expression:

update mytable
    set columnB = (case when columnA < 15 then 0
                        when columnA < 28 then 1
                        when columnA < 43 then 2
                        when columnA < 60 then 3
                   end)
    where columnA < 60;

answered Apr 23, 2018 at 15:38

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

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

Collectives™ on Stack Overflow

SQL update query with IF ELSE

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related