๐Ÿ“ ์•Œ๊ณ ๋ฆฌ์ฆ˜/Programmers - SQL

[MySQL/PGS] Lv.3 : ๋ฌผ๊ณ ๊ธฐ ์ข…๋ฅ˜ ๋ณ„ ๋Œ€์–ด ์ฐพ๊ธฐ

xxilliant 2025. 6. 28. 22:59
728x90
๋ฐ˜์‘ํ˜•

 

https://school.programmers.co.kr/learn/courses/30/lessons/293261

 

ํ”„๋กœ๊ทธ๋ž˜๋จธ์Šค

SW๊ฐœ๋ฐœ์ž๋ฅผ ์œ„ํ•œ ํ‰๊ฐ€, ๊ต์œก์˜ Total Solution์„ ์ œ๊ณตํ•˜๋Š” ๊ฐœ๋ฐœ์ž ์„ฑ์žฅ์„ ์œ„ํ•œ ๋ฒ ์ด์Šค์บ ํ”„

programmers.co.kr


ํ”„๋กœ๊ทธ๋ž˜๋จธ์Šค ๋ ˆ๋ฒจ 3

group by, max ๋“ฑ์„ ์‘์šฉํ•˜๋Š” ๋ฌธ์ œ

 

๋‚˜์˜ ํ’€์ด

SELECT f.ID, fn.FISH_NAME, f.LENGTH 
FROM FISH_INFO f
INNER JOIN FISH_NAME_INFO fn
ON f.FISH_TYPE = fn.FISH_TYPE
WHERE (f.FISH_TYPE, f.LENGTH) IN (SELECT FISH_TYPE, MAX(LENGTH)
		FROM FISH_INFO
		GROUP BY FISH_TYPE)
ORDER BY 1;

728x90
๋ฐ˜์‘ํ˜•