-
627. Swap Salary mysqlLeetCode_Study_Plan/SQL 2022. 9. 26. 21:48
https://leetcode.com/problems/swap-salary/?envType=study-plan&id=sql-i
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 Salary SET sex = IF (sex = 'f','m','f')SQL의 if는 DDL에서도 사용 가능
'LeetCode_Study_Plan > SQL' 카테고리의 다른 글
1667. Fix Names in a Table oracle (0) 2022.09.27 196. Delete Duplicate Emails mysql (0) 2022.09.26 1873. Calculate Special Bonus mysql (0) 2022.09.26 183. Customers Who Never Order mysql (1) 2022.09.25 584. Find Customer Referee mysql (0) 2022.09.25