[05단원] Where절과 연산자

 

교재명 : Do it! 오라클로 배우는 데이터베이스 입문 (이지스퍼블리싱 / 이지훈 지음)

 

 [ Q1 ] 

 

 [ A1 ] 

SELECT *
  FROM EMP
 WHERE ENAME LIKE '%S';

 

 [ Q2 ] 

 

 [ A2 ] 

SELECT EMPNO, ENAME, JOB, SAL, DEPTNO
  FROM EMP 
 WHERE DEPTNO = 30
   AND JOB = 'SALESMAN';

 

 [ Q3 ] 

 

 [ A3 ] 

-- 집합연산자를 사용하지 않은 방식
SELECT EMPNO, ENAME, JOB, SAL, DEPTNO
  FROM EMP
 WHERE DEPTNO IN (20, 30) 
   AND SAL > 2000;

-- 집합연산자를 사용한 방식
SELECT EMPNO, ENAME, JOB, SAL, DEPTNO
  FROM EMP
 WHERE DEPTNO = 20
   AND SAL > 2000
UNION
SELECT EMPNO, ENAME, JOB, SAL, DEPTNO
  FROM EMP
 WHERE DEPTNO = 30
   AND SAL > 2000;

 

 

 [ Q4 ] 

 [ A4 ] 

SELECT * 
  FROM EMP
 WHERE SAL < 2000
    OR SAL > 3000;

 

 [ Q5 ] 

 [ A5 ] 

SELECT ENAME, EMPNO, SAL, DEPTNO
  FROM EMP
 WHERE DEPTNO = 30
   AND ENAME LIKE '%E%'
   AND SAL NOT BETWEEN 1000 AND 2000;

 

 [ Q6 ] 

 [ A6 ] 

SELECT *
  FROM EMP
 WHERE COMM IS NULL
   AND MGR IS NOT NULL
   AND JOB IN ('MANAGER', 'CLERK')
   AND ENAME NOT LIKE '_L%';

 

---

 [ 참고자료 ]

• https://github.com/GroovySunday/doit-oracle