JAVA/JDBC
WHERE절 주요 연산자
데브사냥
2015. 3. 3. 20:08
-- and / or / LIKE
SELECT dept_id, dept_name, location
FROM DEPARTMENT
WHERE location = '서울' or dept_name LIKE '영업%';
WHERE location = '서울' and dept_name [NOT] LIKE '영업_';
-- in
SELECT dept_id, dept_name, location
FROM DEPARTMENT
WHERE location [NOT] IN ('서울',부산');
-- between
SELECT dept_id, dept_name, location
FROM DEPARTMENT
WHERE dept_id >= 100 and dept_id <=300;
WHERE dept_id [NOT] BETWEEN 100 AND 300;
-- null
SELECT dept_id, dept_name, location
FROM DEPARTMENT
WHERE location IS NULL;
WHERE location IS NOT NULL;
반응형