DDSA
Advertisement

627. Swap Salary

627.sql
MySQL
UPDATE Salary
SET sex = CASE WHEN sex = 'm' THEN  'f' ELSE  'm' END;
Advertisement
Was this solution helpful?