Update data using case statement

Опубликовано: 18 Март 2025
на канале: OPEN SOURCE GURU JI

347

Update data using case statement.
Write the SQL statement to find the 2nd & 3rd maximum salary of an employee?
====================================
SQL-Interview-Questions
====================================
Hello Friends,
I hope this video will help you to write down the SQL statement to find nth salary of employee.

You can access article link below:
(https) opensourceguruji.com/sql-interview-questions/

Code:
update person set gender=case gender when 'Male' then 'Female' when 'Female' then 'Male' else gender end;

Thanks,
Open source.