SQL 627 Swap Salary

本文主要是介绍SQL 627 Swap Salary，对大家解决编程问题具有一定的参考价值，需要的程序猿们随着小编来一起学习吧！

Table: Salary

+-------------+----------+
| Column Name | Type     |
+-------------+----------+
| id          | int      |
| name        | varchar  |
| sex         | ENUM     |
| salary      | int      |
+-------------+----------+

id is the primary key for this table.
The sex column is ENUM value of type ('m', 'f').
The table contains information about an employee.

Write an SQL query to swap all 'f' and 'm' values (i.e., change all 'f' values to 'm' and vice versa) with a single update statement and no intermediate temporary tables.

Note that you must write a single update statement, do not write any select statement for this problem.

Solution

这里使用 \(SET\)，具体用法见代码

UPDATE Salary
SET sex=
(case
    WHEN sex='f' THEN 'm'
    ELSE 'f'
end)

这篇关于SQL 627 Swap Salary的文章就介绍到这儿，希望我们推荐的文章对大家有所帮助，也希望大家多多支持为之网！