How to update multiple rows in a single column in sql

Question

I want to update multiple rows in a single column ex-update <table name>set department=clerk, analyst where empoyeeid=1,2

Answer 1

If you are using SQL Server, then maybe the CHOOSE function would help:

update <table name> set department=CHOOSE(employeeid, 'clerk', 'analyst') where empoyeeid in (1,2)