๐ ์๊ณ ๋ฆฌ์ฆ/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
๋ฐ์ํ