MYSQL - 집계함수

집계 함수

집계함수의 종류

SELECT count(javascript) from myrecode;

SELECT sum(javascript) from myrecode;

SELECT avg(javascript) from myrecode;

SELECT max(javascript) from myrecode;

SELECT min(javascript) from myrecode;

그룹별 집계

GROUP BY

SELECT 필드명 FROM 테이블명 GROUP BY 필드명

SELECT memberID avg(javascript) from myrecode WHERE memberID IN(1,2,3,4) GROUP BY memberID;