조건문

조건을 나타내는 방법

 

나이 20 - 29 사이의 회원 조회

SELECT * FROM member WHERE age>= 20 AND age<=29;
SELECT * FROM member WHERE age BETWEEN 20 AND 29;

 

나이 20 - 29 사이의 회원 제외

SELECT * FROM member WHERE age NOR BETWEEN 20 AND 29;

 

날짜 

SELECT * FROM member WHERE sign_up_date > '2021-09-05';
SELECT * FROM member WHERE sign_up_date BETWEEN '2021-01-01' AND '2021-12-31';