SQL BETWEEN 연산자

1 개요

SQL BETWEEN Operator

SQL BETWEEEN 연산자

• 범위 내의 값(예: 숫자, 문자, 날짜)을 선택하는 연산자

2 예시

SELECT * FROM Products
WHERE Price BETWEEN 10 AND 20;

SELECT * FROM Products
WHERE Price NOT BETWEEN 10 AND 20;

SELECT * FROM Products
WHERE ProductName BETWEEN 'C' AND 'M';

3 같이 보기

• SQL 비교 연산자
• WHERE 절

4 참고 자료

• http://www.w3schools.com/sql/sql_between.asp