leetcode

Leetcode submissions
git clone git://git.laack.co/leetcode.git
Log | Files | Refs | README

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