====================================================
\n\uc22b\uc790\ub85c \uc9c0\uc815\ud558\uba74 \ub428….<\/p>\n
SQL> select empno, ename
\n 2 from emp
\n 3 where sal > 1000
\n 4 MINUS
\n 5 select empno, ename
\n 6 from emp
\n 7 where sal > 2000
\n 8 ORDER BY 2;<\/p>\n
====================================================<\/p>\n
SQL> CREATE TABLE EMP (EMPNO NUMBER(4) NOT NULL,
\n 2 ENAME VARCHAR2(10),
\n 3 JOB VARCHAR2(9),
\n 4 MGR NUMBER(4),
\n 5 HIREDATE DATE,
\n 6 SAL NUMBER(7, 2),
\n 7 COMM NUMBER(7, 2),
\n 8 DEPTNO NUMBER(2));
\nSQL>
\nSQL> INSERT INTO EMP VALUES (7369, ‘SMITH’, ‘CLERK’, 7902, TO_DATE(’17-DEC-1980′, ‘DD-MON-YYYY’), 800, NULL, 20);
\nSQL> INSERT INTO EMP VALUES (7499, ‘ALLEN’, ‘SALESMAN’, 7698, TO_DATE(’20-FEB-1981′, ‘DD-MON-YYYY’), 1600, 300, 30);
\nSQL> INSERT INTO EMP VALUES (7521, ‘WARD’, ‘SALESMAN’, 7698, TO_DATE(’22-FEB-1981′, ‘DD-MON-YYYY’), 1250, 500, 30);
\nSQL> INSERT INTO EMP VALUES (7566, ‘JONES’, ‘MANAGER’, 7839, TO_DATE(‘2-APR-1981’, ‘DD-MON-YYYY’), 2975, NULL, 20);
\nSQL> INSERT INTO EMP VALUES (7654, ‘MARTIN’, ‘SALESMAN’, 7698,TO_DATE(’28-SEP-1981′, ‘DD-MON-YYYY’), 1250, 1400, 30);
\nSQL> INSERT INTO EMP VALUES (7698, ‘BLAKE’, ‘MANAGER’, 7839,TO_DATE(‘1-MAY-1981’, ‘DD-MON-YYYY’), 2850, NULL, 30);
\nSQL> INSERT INTO EMP VALUES (7782, ‘CLARK’, ‘MANAGER’, 7839,TO_DATE(‘9-JUN-1981’, ‘DD-MON-YYYY’), 2450, NULL, 10);
\nSQL> INSERT INTO EMP VALUES (7788, ‘SCOTT’, ‘ANALYST’, 7566,TO_DATE(’09-DEC-1982′, ‘DD-MON-YYYY’), 3000, NULL, 20);
\nSQL> INSERT INTO EMP VALUES (7839, ‘KING’, ‘PRESIDENT’, NULL,TO_DATE(’17-NOV-1981′, ‘DD-MON-YYYY’), 5000, NULL, 10);
\nSQL> INSERT INTO EMP VALUES (7844, ‘TURNER’, ‘SALESMAN’, 7698,TO_DATE(‘8-SEP-1981’, ‘DD-MON-YYYY’), 1500, 0, 30);
\nSQL> INSERT INTO EMP VALUES (7876, ‘ADAMS’, ‘CLERK’, 7788,TO_DATE(’12-JAN-1983′, ‘DD-MON-YYYY’), 1100, NULL, 20);
\nSQL> INSERT INTO EMP VALUES (7900, ‘JAMES’, ‘CLERK’, 7698,TO_DATE(‘3-DEC-1981’, ‘DD-MON-YYYY’), 950, NULL, 30);
\nSQL> INSERT INTO EMP VALUES (7902, ‘FORD’, ‘ANALYST’, 7566,TO_DATE(‘3-DEC-1981’, ‘DD-MON-YYYY’), 3000, NULL, 20);
\nSQL> INSERT INTO EMP VALUES (7934, ‘MILLER’, ‘CLERK’, 7782,TO_DATE(’23-JAN-1982′, ‘DD-MON-YYYY’), 1300, NULL, 10);
\nSQL>
\nSQL>
\nSQL> select * from emp;<\/p>\n
EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
\n———- ———- ——— ———- ——— ———- ———- ———-
\n 7369 SMITH CLERK 7902 17-DEC-80 800 20
\n 7499 ALLEN SALESMAN 7698 20-FEB-81 1600 300 30
\n 7521 WARD SALESMAN 7698 22-FEB-81 1250 500 30
\n 7566 JONES MANAGER 7839 02-APR-81 2975 20
\n 7654 MARTIN SALESMAN 7698 28-SEP-81 1250 1400 30
\n 7698 BLAKE MANAGER 7839 01-MAY-81 2850 30
\n 7782 CLARK MANAGER 7839 09-JUN-81 2450 10
\n 7788 SCOTT ANALYST 7566 09-DEC-82 3000 20
\n 7839 KING PRESIDENT 17-NOV-81 5000 10
\n 7844 TURNER SALESMAN 7698 08-SEP-81 1500 0 30
\n 7876 ADAMS CLERK 7788 12-JAN-83 1100 20<\/p>\n
EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
\n———- ———- ——— ———- ——— ———- ———- ———-
\n 7900 JAMES CLERK 7698 03-DEC-81 950 30
\n 7902 FORD ANALYST 7566 03-DEC-81 3000 20
\n 7934 MILLER CLERK 7782 23-JAN-82 1300 10
\nSQL>
\nSQL> — With ORDER BY Clause
\nSQL>
\nSQL> — An MINUS query that uses an ORDER BY clause:
\nSQL>
\nSQL> select empno, ename
\n 2 from emp
\n 3 where sal > 1000
\n 4 MINUS
\n 5 select empno, ename
\n 6 from emp
\n 7 where sal > 2000
\n 8 ORDER BY 2;<\/p>\n
EMPNO ENAME
\n———- ———-
\n 7876 ADAMS
\n 7499 ALLEN
\n 7654 MARTIN
\n 7934 MILLER
\n 7844 TURNER
\n 7521 WARD
\nSQL>
\nSQL> drop table emp;
\nSQL>
\nSQL>
\nSQL>
\nSQL>
\nSQL><\/p>\n","protected":false},"excerpt":{"rendered":"
==================================================== \uc22b\uc790\ub85c \uc9c0\uc815\ud558\uba74 \ub428…. SQL> select empno, ename 2 from emp 3 where sal > 1000 4 MINUS 5 select empno, ename 6 from emp 7 where sal > 2000… <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"_links":{"self":[{"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=\/wp\/v2\/posts\/591"}],"collection":[{"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=591"}],"version-history":[{"count":0,"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=\/wp\/v2\/posts\/591\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=591"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=591"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=591"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}