TIL, WIL/TIL๐Ÿ“˜

12.05 TIL : GROUP BY ์ ˆ์—์„œ HAVING COUNT์˜ ์—ญํ•  ์™ธ

wannaDevelopIt 2023. 12. 5. 12:26
728x90

GROUP BY์ ˆ์—์„œ ํŠน์ • ์นผ๋Ÿผ์— ๋Œ€ํ•œ COUNT ์กฐ๊ฑด์„ ์„ค์ •ํ•˜๊ณ  ์‹ถ์„ ๋–„ having count๋ฅผ ์‚ฌ์šฉํ•œ๋‹ค

 

+ SYS_CONECT_BY_PATH

+ LAPD, RPAD

 

728x90
์ €์ž‘์žํ‘œ์‹œ ๋น„์˜๋ฆฌ ๋ณ€๊ฒฝ๊ธˆ์ง€ (์ƒˆ์ฐฝ์—ด๋ฆผ)