[SQL]서브쿼리(IN,ANY,SOME ALL,EXISTS )
/* 제임스의 급여보다 큰 사원 출력*/ SELECT *FROM EMP WHERE SAL>(SELECT SAL FROM EMP WHERE ENAME = 'JONES'); SELECT * FROM EMP WHERE COMM>(SELECT COMM FROM EMP WHERE ENAME='ALLEN'); /*단일 행 서브 쿼리*/ SELECT E.EMPNO,E.ENAME,E.JOB,E.SAL,D.DEPTNO,D.DNAME,D.LOC FROM EMP E, DEPT D WHERE E.DEPTNO=D.DEPTNO AND E.DEPTNO = 20 AND SAL>(SELECT AVG(SAL) FROM EMP); /*238P 1분 복습*/ SELECT E.EMPNO,E.ENAME,E.JOB,E.SAL,D.DEPTNO,D..
2020. 6. 11.
[SQL]비교연산자,AND,OR,IN,BETWEEN,LIKE,합집합(UNION),차집합(MINUS),교집합(INTERSECT)
/*비교연산자*/ /* !=, , ^=, not */ SELECT * FROM emp where deptno !=10 and deptno !=30; SELECT * FROM emp where deptno 10 and deptno 30; SELECT * FROM emp where deptno ^=10 and deptno ^=30; SELECT * FROM emp where not sal=3000; /*OR, IN*/ SELECT * FROM emp where job='MANAGER' or job='SALESMAN' or job='CLERK'; /*IN*/ SELECT * FROM emp where job in ('MANAGER','SALESMAN','CLERK'); SELECT * FROM emp wher..
2020. 6. 11.