๋ณธ๋ฌธ ๋ฐ”๋กœ๊ฐ€๊ธฐ

Basic/[SQL] Leetcode ํ’€์ด๋…ธํŠธ

[LeetCode | Easy] 627. Swap Salary

๐Ÿ”ป ๋ฌธ์ œ ๋งํฌ

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'์ด ๋œ๋‹ค.