swap-salary.sql (157B)
1 --Given a table update all 2 --sexes to the opposite 3 UPDATE Salary 4 SET Salary.sex = CASE 5 WHEN Salary.sex = 'm' then 'f' 6 WHEN Salary.sex = 'f' then 'm' 7 END
leetcodeLeetcode submissions | |
| git clone git://git.laack.co/leetcode.git | |
| Log | Files | Refs | README |