[Oracle] 비교연산자 (BETWEEN AND)

비교연산자(BETWEEN AND)

- 두 값 사이의 값 검색

--BETWEEN 하한값 AND 상한값
SELECT column1, column2
	FROM tablename
    WHERE column2 BETWEEN 2000 AND 4000;
    
--위 와 같음
SELECT column1, column2
	FROM tablename
    WHERE (column2 >= 2000 AND column2 <= 4000);

- 두 값 사이의 값이 아닌 경우

SELECT column1, column2
	FROM tablename
    WHERE column2 NOT BETWEEN 2000 AND 4000;
    
--위과 같음
SELECT column1, column2
	FROM tablename
    WHERE (column2 < 2000 OR column2 > 3000);

 

- 날짜

SELECT column1, column2
	FROM tablename
    WHERE column2 BETWEEN '2020/08/01' AND '2020/08/19';