Given a table SALARIES, such as the one below, that has m and f values. Swap all f and m values with a single update query and no intermediate temp table.


Id Name Sex Salary 1 A m 2500 2 B f 1500 3 C m 5500 4 D f 500

UPDATE SALARIES SET sex = CASE sex WHEN 'm' THEN 'f' ELSE 'm' END