JuneBee
Home
  • ๋ถ„๋ฅ˜ ์ „์ฒด๋ณด๊ธฐ (86)
    • ๐Ÿ‘” JOB (10)
      • ์ „ํ˜• ํ›„๊ธฐ (10)
    • ๐ŸŽฎ GAME (9)
      • ์ ค๋‹ค | ์™•๊ตญ์˜ ๋ˆˆ๋ฌผ ๊ฒŒ์ž„ ์ผ๊ธฐ (9)
    • ๐Ÿ““ STUDY (60)
      • JAVA (15)
      • TIL (2)
      • FASTCAMPUS (32)
      • ํ™˜๊ฒฝ์„ค์ • (2)
      • YOCTO (1)
      • OS (4)
      • ๋ฆฌ์•กํŠธ ๋„ค์ดํ‹ฐ๋ธŒ ์ธ ์•ก์…˜ (2)
    • ๐ŸŽงDAILY (6)
    • ๐Ÿ‡ฉ๐Ÿ‡ช GERMAN (1)
      • A1 (0)
Home
  • ๋ถ„๋ฅ˜ ์ „์ฒด๋ณด๊ธฐ (86)
    • ๐Ÿ‘” JOB (10)
      • ์ „ํ˜• ํ›„๊ธฐ (10)
    • ๐ŸŽฎ GAME (9)
      • ์ ค๋‹ค | ์™•๊ตญ์˜ ๋ˆˆ๋ฌผ ๊ฒŒ์ž„ ์ผ๊ธฐ (9)
    • ๐Ÿ““ STUDY (60)
      • JAVA (15)
      • TIL (2)
      • FASTCAMPUS (32)
      • ํ™˜๊ฒฝ์„ค์ • (2)
      • YOCTO (1)
      • OS (4)
      • ๋ฆฌ์•กํŠธ ๋„ค์ดํ‹ฐ๋ธŒ ์ธ ์•ก์…˜ (2)
    • ๐ŸŽงDAILY (6)
    • ๐Ÿ‡ฉ๐Ÿ‡ช GERMAN (1)
      • A1 (0)
๋ธ”๋กœ๊ทธ ๋‚ด ๊ฒ€์ƒ‰

JuneBee

โ‚Šหš.๐ŸŽง๐Ÿ““ ๊ธฐ๋ก์šฉ ๋ธ”๋กœ๊ทธ ๐“‚ƒ๐Ÿ–Š

  • ๐Ÿ““ STUDY/FASTCAMPUS

    ํŒจ์ŠคํŠธ์บ ํผ์Šค ์ฑŒ๋ฆฐ์ง€ 27์ผ์ฐจ

    2021. 11. 27.

    by. JuneBee

    728x90
    ๋ฐ˜์‘ํ˜•

    CH04_03. ์ˆœ์œ„ ์ง‘๊ณ„(rank, dense-rank, row-number), ์กฐ์ธ

    ๋‚ ์งœ : 11/27/2021

    RANK

    rank(๊ฐ’) over (partition by ๋Œ€์ƒ order by ๋Œ€์ƒ)

    
    SELECT
        ranking_no, ranking_score, ranking_name,
        ( @rank := @rank + 1 ) AS rank
    FROM
        ranking AS a,
        ( SELECT @rank := 0 ) AS b
    ORDER BY
        a.ranking_score DESC;
    

    MySQL ์—๋„ ํ”„๋กœ๊ทธ๋žจ์˜ ๋ณ€์ˆ˜์™€ ๊ฐ™์€ ๊ฐœ๋…์œผ๋กœ @๋ณ€์ˆ˜๋ช…์„ ์ด์šฉํ•ด ๊ฐ’์„ ์œ ์ง€ํ•  ์ˆ˜ ์žˆ๋‹ค.
    ๋‹ค๋งŒ "@๋ณ€์ˆ˜๋ช…" ์€ ๋ชจ๋“  connect ์— ์œ ํšจํ•œ ๊ฐ’์ด ์•„๋‹ˆ๊ณ , ํ•ด๋‹น connect session ์—์„œ๋งŒ ์œ ํšจํ•œ ๊ฐ’์ด๋‹ค.

    DENSE-RANK

    ์ค‘๋ณต ๊ฐ’๋“ค์— ๋Œ€ํ•ด์„œ๋Š” ๋™์ผ ์ˆœ์œ„๋กœ ํ‘œ์‹œํ•˜๊ณ , ์ค‘๋ณต ์ˆœ์œ„ ๋‹ค์Œ ๊ฐ’์— ๋Œ€ํ•ด์„œ๋Š” ์ค‘๋ณต ๊ฐ’ ๊ฐœ์ˆ˜์™€ ์ƒ๊ด€์—†์ด ์ˆœ์ฐจ์ ์ธ ์ˆœ์œ„ ๊ฐ’์„ ์ถœ๋ ฅํ•˜๋„๋ก ํ•˜๋Š” ํ•จ์ˆ˜

    SELECT *, dense_rank() over(order by Population desc) AS ranking
    FROM city;

    ROW-Number

    ์ค‘๋ณต ๊ฐ’๋“ค์— ๋Œ€ํ•ด์„œ๋„ ์ˆœ์ฐจ์ ์ธ ์ˆœ์œ„๋ฅผ ํ‘œ์‹œํ•˜๋„๋ก ์ถœ๋ ฅํ•˜๋Š” ํ•จ์ˆ˜

    SELECT ranking_no, ranking_score, ranking_Name,
    OVER (ORDER BY ranking_score DESC) " RANK",
    FROM ranking

    ํŒจ์ŠคํŠธ์บ ํผ์Šค ํ™˜๊ธ‰ ์ฑŒ๋ฆฐ์ง€ ๋ฐ”๋กœ๊ฐ€๊ธฐ๐Ÿ‘‰ https://bit.ly/3FVdhDa

     

    ์ˆ˜๊ฐ•๋ฃŒ 100% ํ™˜๊ธ‰ ์ฑŒ๋ฆฐ์ง€ | ํŒจ์ŠคํŠธ์บ ํผ์Šค

    ๋”ฑ 5์ผ๊ฐ„ ์ง„ํ–‰๋˜๋Š” ํ™˜๊ธ‰์ฑŒ๋ฆฐ์ง€๋กœ ์ˆ˜๊ฐ•๋ฃŒ 100% ํ™˜๊ธ‰๋ฐ›์œผ์„ธ์š”! ๋” ๋Šฆ๊ธฐ์ „์— ์ž๊ธฐ๊ณ„๋ฐœ ๋ง‰์ฐจ ํƒ‘์Šน!

    fastcampus.co.kr

    ๋ณธ ํฌ์ŠคํŒ…์€ ํŒจ์ŠคํŠธ์บ ํผ์Šค ํ™˜๊ธ‰ ์ฑŒ๋ฆฐ์ง€ ์ฐธ์—ฌ๋ฅผ ์œ„ํ•ด ์ž‘์„ฑ๋˜์—ˆ์Šต๋‹ˆ๋‹ค

    728x90
    ๋ฐ˜์‘ํ˜•

    '๐Ÿ““ STUDY > FASTCAMPUS' ์นดํ…Œ๊ณ ๋ฆฌ์˜ ๋‹ค๋ฅธ ๊ธ€

    ํŒจ์ŠคํŠธ์บ ํผ์Šค ์ฑŒ๋ฆฐ์ง€ 29์ผ์ฐจ  (0) 2021.11.29
    ํŒจ์ŠคํŠธ์บ ํผ์Šค ์ฑŒ๋ฆฐ์ง€ 28์ผ์ฐจ  (2) 2021.11.28
    ํŒจ์ŠคํŠธ์บ ํผ์Šค ์ฑŒ๋ฆฐ์ง€ 26์ผ์ฐจ  (0) 2021.11.26
    ํŒจ์ŠคํŠธ์บ ํผ์Šค ์ฑŒ๋ฆฐ์ง€ 25์ผ์ฐจ  (0) 2021.11.25
    ํŒจ์ŠคํŠธ์บ ํผ์Šค ์ฑŒ๋ฆฐ์ง€ 24์ผ์ฐจ  (0) 2021.11.24

    ๋Œ“๊ธ€

    ๊ด€๋ จ๊ธ€

    • ํŒจ์ŠคํŠธ์บ ํผ์Šค ์ฑŒ๋ฆฐ์ง€ 29์ผ์ฐจ 2021.11.29
    • ํŒจ์ŠคํŠธ์บ ํผ์Šค ์ฑŒ๋ฆฐ์ง€ 28์ผ์ฐจ 2021.11.28
    • ํŒจ์ŠคํŠธ์บ ํผ์Šค ์ฑŒ๋ฆฐ์ง€ 26์ผ์ฐจ 2021.11.26
    • ํŒจ์ŠคํŠธ์บ ํผ์Šค ์ฑŒ๋ฆฐ์ง€ 25์ผ์ฐจ 2021.11.25
    ๋งจ ์œ„๋กœ
์ „์ฒด ๊ธ€ ๋ณด๊ธฐ
Tistory ๋กœ๊ทธ์ธ
Tistory ๋กœ๊ทธ์•„์›ƒ
๋กœ๊ทธ์•„์›ƒ ๊ธ€์“ฐ๊ธฐ ๊ด€๋ฆฌ

Today

Total

Powered by โ“’ Kakao Corp.

Designed by Nana
๋ธ”๋กœ๊ทธ ์ด๋ฏธ์ง€
JuneBee

ํ‹ฐ์Šคํ† ๋ฆฌํˆด๋ฐ”