MIN 1
MAX, MIN, COUNT, DISTINCT

โ“MAX SELECT max(์—ด) FROM (ํ…Œ์ด๋ธ”)  โ“MIN SELECT min(์—ด) FROM (ํ…Œ์ด๋ธ”)  โ“COUNT SELECT count(*) as (์—ด ์ด๋ฆ„) FROM (ํ…Œ์ด๋ธ”) count(*) : ํ…Œ์ด๋ธ” ์ „์ฒด์˜ ํ–‰ ๊ฐœ์ˆ˜, null ํฌํ•จcount(์—ด): ํŠน์ • ์—ด์˜ ๊ฐœ์ˆ˜, null ์ œ์™ธ  โ“DISTINCT - ์ค‘๋ณต์„ ์ œ๊ฑฐ- ์ค‘๋ณต ์ œ๊ฑฐํ•˜๋ ค๋Š” ์—ด ์•ž์— DISTINCT ์ถ”๊ฐ€
โ˜๏ธ์ •๋ฆฌ/โ„๏ธSQL 2022.01.13
1

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