๐ป ๋ฌธ์ ๋งํฌ
https://leetcode.com/problems/swap-salary/?envType=study-plan&id=sql-i
Swap Salary - LeetCode
Can you solve this real interview question? Swap Salary - Table: Salary +-------------+----------+ | Column Name | Type | +-------------+----------+ | id | int | | name | varchar | | sex | ENUM | | salary | int | +-------------+----------+ id is the primar
leetcode.com
๐ป ๋ฌธ์ ํด๊ฒฐ
ํ ์ด๋ธ์์ ๊ฐ์ ์์ ํ๋ ๋ฌธ์ ์ด๋ค.
select๋ฌธ์ ์ฐ์ง ์์์ผ ํ๊ธฐ ๋๋ฌธ์ UPDATE ~ SET์ ์ฌ์ฉํด์ ๊ฐ์ ์์ ํด์ค๋ค.
'm'์ธ ๊ฒฝ์ฐ๋ 'f'๋ก, 'f'๋ 'm'์ผ๋ก ๊ฐ์ ๋ฐ๊ฟ์ฃผ์ด์ผ ํ๊ธฐ ๋๋ฌธ์ if๋ฌธ์ ์ฌ์ฉํด์ค๋ค.
update salary
set sex = if(sex = 'm', 'f', 'm')
์ฐธ๊ณ )
if ( ์กฐ๊ฑด, True, False) ์ด๊ธฐ ๋๋ฌธ์
๋ง์ฝ ์ฑ๋ณ์ด 'm'์ธ ๊ฒฝ์ฐ๋ 'f'๊ฐ ๋๊ณ , ์ฑ๋ณ์ด 'm'์ด ์๋ ๊ฒฝ์ฐ(=์ฑ๋ณ์ด 'f'์ธ ๊ฒฝ์ฐ)๋ 'm'์ด ๋๋ค.
'Basic > [SQL] Leetcode ํ์ด๋ ธํธ' ์นดํ ๊ณ ๋ฆฌ์ ๋ค๋ฅธ ๊ธ
[LeetCode | Easy] 1873. Calculate Special Bonus (0) | 2023.03.19 |
---|---|
[LeetCode | Easy] 196. Delete Duplicate Emails (0) | 2023.03.19 |
[LeetCode | Easy] 183. Customers Who Never Order (0) | 2023.03.17 |
[LeetCode | Easy] 584. Find Customer Referee (0) | 2023.03.17 |
[LeetCode | Easy] 595. Big Countries (0) | 2023.03.17 |