SELECT COUNT(*) FROM copang_main.member;
SELECT MAX(height) FROM copang_main.member;
SELECT MIN(height) FROM copang_main.member;
SELECT AVG(weight) FROM copang_main.member;
SELECT SUM(age) FROM copang_main.member;
SELECT STD(age) FROM copang_main.member;
SELECT ABS(height) FROM copang_main.member;
SELECT SQRT(height) FROM copang_main.member;
SELECT CEIL(height) FROM copang_main.member;
SELECT FLOOR(height) FROM copang_main.member;
SELECT ROUND(height) FROM copang_main.member;
SELECT * FROM copang_main.member WHERE address IS NULL;
// NULL이 있는 row를 show
SELECT * FROM copang_main.member WHERE address IS NOT NULL;
// NULL이 없는 row를 show
SELECT COALESCE(height, '####'),
COALESCE(height, '----'),
COALESCE(height, '@@@@'),
FROM copang_main.member;
SELECT * FROM copang_main.member WHERE age BETWEEN 5 AND 90;
// 나이가 5살에서 90살인 사람만 조회
SELECT * FROM copang_main.member WHERE address NOT LIKE '%호';
// ~~호로 입력하지 않은 사람들만 조회
본 포스트는 코드잇 강의를 공부하며 정리한 내용입니다! 자세한 설명은 "코드잇 머신러닝 강의를 참고해주세요!