코딩 연습/SQL

leetcode 627 swap salary

썬2 2022. 8. 9. 21:14

https://leetcode.com/problems/swap-salary/

 

Swap Salary - LeetCode

Level up your coding skills and quickly land a job. This is the best place to expand your knowledge and get prepared for your next interview.

leetcode.com

 

update 한번만 쓰기

 

update salary
set sex = case 
            when sex='f' then 'm' 
            else 'f' end