[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.