[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.
[SQL]테이블 확인,생성,삭제,삽입
/*테이블 확인*/ SELECT * FROM TAB; SELECT * FROM TABS; /*테이블 생성*/ CREATE TABLE DEPT_TEMP AS SELECT * FROM DEPT; /*테이블 삭제*/ DROP TABLE DEPT_TEMP; /*데이터 삽입 */ INSERT INTO DEPT_TEMP (DEPTNO,DNAME,LOC) VALUES (50,'DATABASE','SEOUL'); /* NULL데이터 삽입*/ INSERT INTO DEPT_TEMP (DEPTNO,DNAME,LOC) VALUES (70,'WEB',NULL); INSERT INTO DEPT_TEMP (DEPTNO,DNAME,LOC) VALUES (80,'MOBILE',''); INSERT INTO DEPT_TEMP (DEP..
2020. 6. 11.