Example 1 SQLSELECT empno emp ename emp deptno

Example 1 SQL>SELECT empno, emp. ename, emp. deptno, dept. loc FROM emp, dept WHERE

Example 2 SQL>SELECT e. empno, e. ename, e. deptno, d. loc FROM emp e,

Example 3 SQL>SELECT e. ename, e. sal, s. grade FROM emp e, salgrade s

Example 4 SQL>SELECT e. empno, e. ename, d. deptno, d. dname FROM emp e,

Example 4 EMPNO ENAME DEPTNO DNAME 7782 7839 7934 7369 7876 7902 7788 7566

Example 5 SQL>SELECT worker. empno, worker. ename, manager. ename manager FROM emp worker, emp

Example 5 EMPNO ENAME MANAGER 7369 7499 7521 7566 7654 7698 7782 7788 7844

Example 6 SQL>SELECT e. empno, e. ename, e. sal, d. dname, s. grade FROM

Example 6 EMPNO ENAME SAL DNAME GRADE 7369 7876 7900 7521 7654 7934 7499

Slides: 17

Download presentation

Example 1 SQL>SELECT empno, emp. ename, emp. deptno, dept. loc FROM emp, dept WHERE emp. deptno = deptno; EMPNO ENAME DEPTNO LOC 7369 7499 7521 7566 7654 7698 7782 7788 7839 7844 7876 SMITH ALLEN WARD JONES MARTIN BLAKE CLARK SCOTT KING TURNER ADAMS 20 30 30 10 20 10 30 20 DALLAS CHICAGO NEW YORK DALLAS NEW YORK CHICAGO DALLAS

Example 2 SQL>SELECT e. empno, e. ename, e. deptno, d. loc FROM emp e, dept d WHERE e. deptno = d. deptno AND e. ename = UPPER(‘king’); EMPNO ENAME DEPTNO LOC 7839 KING 10 10 NEW YORK

Example 3 SQL>SELECT e. ename, e. sal, s. grade FROM emp e, salgrade s WHERE e. sal BETWEEN s. losal AND s. hisal; ENAME SAL GRADE SMITH ADAMS JAMES WARD MARTIN MILLER ALLEN TURNER JONES BLAKE CLARK 800 1100 950 1250 1300 1600 1500 2975 2850 2450 1 1 1 2 2 2 3 3 4 4 4

Example 4 SQL>SELECT e. empno, e. ename, d. deptno, d. dname FROM emp e, dept d WHERE e. deptno(+) = d. deptno;

Example 4 EMPNO ENAME DEPTNO DNAME 7782 7839 7934 7369 7876 7902 7788 7566 7499 7698 7654 7900 7844 7521 CLARK KING MILLER SMITH ADAMS FORD SCOTT JONES ALLEN BLAKE MARTIN JAMES TURNER WARD 10 10 10 20 20 20 30 30 30 40 ACCOUNTING RESEARCH RESEARCH SALES SALES OPERATIONS

Example 5 SQL>SELECT worker. empno, worker. ename, manager. ename manager FROM emp worker, emp manager WHERE worker. mgr = manager. empno;

Example 5 EMPNO ENAME MANAGER 7369 7499 7521 7566 7654 7698 7782 7788 7844 7876 7900 7902 7934 SMITH ALLEN WARD JONES MARTIN BLAKE CLARK SCOTT TURNER ADAMS JAMES FORD MILLER FORD BLAKE KING JONES BLAKE SCOTT BLAKE JONES CLARK

Example 6 SQL>SELECT e. empno, e. ename, e. sal, d. dname, s. grade FROM emp e, dept d, salgrade s WHERE e. deptno = d. deptno AND e. sal BETWEEN s. losal and s. hisal;

Example 6 EMPNO ENAME SAL DNAME GRADE 7369 7876 7900 7521 7654 7934 7499 7844 7566 7698 7782 7788 7902 7839 SMITH ADAMS JAMES WARD MARTIN MILLER ALLEN TURNER JONES BLAKE CLARK SCOTT FORD KING 800 1100 950 1250 1300 1600 1500 2975 2850 2450 3000 5000 RESEARCH SALES ACCOUNTING SALES RESEARCH SALES ACCOUNTING RESEARCH ACCOUNTING 1 1 1 2 2 2 3 3 4 4 4 5