๐Ÿ’ป

[ํ”„๋กœ๊ทธ๋ž˜๋จธ์Šค] ์ฝ”๋”ฉํ…Œ์ŠคํŠธ ์—ฐ์Šต > GROUP BY > ๋ถ€์„œ๋ณ„ ํ‰๊ท  ์—ฐ๋ด‰ ์กฐํšŒํ•˜๊ธฐ ๋ณธ๋ฌธ

์•Œ๊ณ ๋ฆฌ์ฆ˜/๊ธฐ์ดˆ๋‹ค์ง€๊ธฐ

[ํ”„๋กœ๊ทธ๋ž˜๋จธ์Šค] ์ฝ”๋”ฉํ…Œ์ŠคํŠธ ์—ฐ์Šต > GROUP BY > ๋ถ€์„œ๋ณ„ ํ‰๊ท  ์—ฐ๋ด‰ ์กฐํšŒํ•˜๊ธฐ

๋˜ํšจ๋‹ˆ 2024. 11. 2. 01:19

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

 

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

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

programmers.co.kr

LV3. ๋ถ€์„œ๋ณ„ ์—ฐ๋ด‰ ์กฐํšŒํ•˜๊ธฐ

๐Ÿ’ก์•„์ด๋””์–ด

GROUP BY ๋ฌธ์ œ์ด๋‚˜ ํ‰๊ท ํ•จ์ˆ˜ AVG์™€ ๋ฐ˜์˜ฌ๋ฆผ ROUND(๋ฐ˜์˜ฌ๋ฆผํ•  ์ˆซ์ž, ๋ฐ˜์˜ฌ๋ฆผํ•  ์†Œ์ˆ˜์  ์ดํ•˜ ์ž๋ฆฌ์ˆ˜)ํ•จ์ˆ˜๋ฅผ ์“ธ ์ค„ ์•„๋Š”์ง€ ๋ฌผ์–ด๋ณด๋Š” ๋ฌธ์ œ์˜€๋‹ค.

ROUND๋Œ€์‹ ์— ์†Œ์ˆ˜์  ์˜ฌ๋ฆผ CEILING(์ˆซ์ž) ๋ฅผ ์‚ฌ์šฉํ•ด๋„ ๋œ๋‹ค. 

์ด์ฐธ์— ์ ˆ๋Œ€๊ฐ’ ABS(์ˆซ์ž), ์˜ฌ๋ฆผ CEILING(์ˆซ์ž), ๋ฒ„๋ฆผ FLOOR(์ˆซ์ž), ๋ฐ˜์˜ฌ๋ฆผ ROUND(์ˆซ์ž,์ž๋ฆฌ์ˆ˜) ๊ณต๋ถ€ํ•˜์ž.

๐Ÿ’ป ์ฝ”๋“œ์ž‘์„ฑ

-- ์ฝ”๋“œ๋ฅผ ์ž‘์„ฑํ•ด์ฃผ์„ธ์š”
SELECT A.DEPT_ID
    , A.DEPT_NAME_EN
    , B.AVG_SAL
  FROM HR_DEPARTMENT A, (SELECT DEPT_ID
                                , ROUND(AVG(SAL),0) AS AVG_SAL
                         FROM HR_EMPLOYEES
                         GROUP BY DEPT_ID) B
WHERE A.DEPT_ID = B.DEPT_ID
ORDER BY B.AVG_SAL DESC;
๋ฐ˜์‘ํ˜•
Comments