LeetCode_Study_Plan/SQL

627. Swap Salary mysql

개발하는루루 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에서도 사용 가능