g0601_0700.s0627_swap_salary.script.sql Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of leetcode-in-java Show documentation

Java-based LeetCode algorithm problem solutions, regularly updated

The newest version!

# Write your MySQL query statement below
# #Easy #Database #SQL_I_Day_2_Select_and_Order #2022_03_21_Time_191_ms_(96.89%)_Space_0B_(100.00%)
UPDATE Salary SET sex = CASE WHEN sex = 'm' THEN 'f' ELSE 'm' END WHERE TRUE;