๋กœ์ผ“๐Ÿพ
article thumbnail
[Oracle] COUNT() ์ง‘๊ณ„ํ•จ์ˆ˜ ์‚ฌ์šฉํ•˜๊ธฐ
... 2021. 2. 1. 15:01

์˜ค๋ผํด์—์„œ ์ง‘๊ณ„ํ•จ์ˆ˜์ธ COUNT()๋ฅผ ์‚ฌ์šฉํ•˜๋Š” ๋ฐฉ๋ฒ•์ž…๋‹ˆ๋‹ค. SELECT COUNT(CASE WHEN CRSE_TY = '0' THEN 1 END) FROM DUAL # ์˜ˆ์‹œ ํ…Œ์ด๋ธ”์˜ ๋ฐ์ดํ„ฐ๋Š” ์œ„ ์ด๋ฏธ์ง€๋ณด๋‹ค ๋” ๋งŽ์Šต๋‹ˆ๋‹ค. SELECT COUNT(CASE WHEN CRSE_TY = '0' THEN 1 END) AS CRSE_TY_ELRN ,COUNT(CASE WHEN CRSE_TY = '1' THEN 1 END) AS CRSE_TY_OFL ,COUNT(CASE WHEN CRSE_TY = '2' THEN 1 END) AS CRSE_TY_BLEND FROM CRSE_MASTR WHERE EDC_TY = '001' CASE WHEN์„ ์‚ฌ์šฉํ•˜์—ฌ ์ง‘๊ณ„ํ•  ์ปฌ๋Ÿผ์˜ ์กฐ๊ฑด์„ ๊ฑธ์–ด์ฃผ๊ณ  THEN์„ ์‚ฌ์šฉํ•˜์—ฌ ์ผ์น˜ํ•  ๋•Œ 1์„ ๋”ํ•ด..

profile on loading

Loading...