Title | BD PS8 - Rozwiązania zadań SQL z pracowni 8 |
---|---|
Course | Informatyka |
Institution | Politechnika Bialostocka |
Pages | 1 |
File Size | 27.8 KB |
File Type | |
Total Downloads | 101 |
Total Views | 144 |
Rozwiązania zadań SQL z pracowni 8...
/*SELECT E.EMPNO, ENAME FROM EMP1 E JOIN SALGRADE1 ON SAL BETWEEN LOSAL AND HISAL AND GRADE > 3 LEFT JOIN IMPLEMP1 IE ON E.EMPNO = IE.EMPNO AND IE.IMPL = NULL;*/ /*SELECT E1.EMPNO, ENAME FROM EMP1 E1, SALGRADE WHERE SAL BETWEEN LOSAL AND HISAL AND GRADE > 3 AND NOT EXISTS (SELECT EMPNO FROM IMPLEMP1 I1 WHERE E1.EMPNO = I1.EMPNO);*/ /*SELECT E.EMPNO, ENAME FROM EMP1 E, SALGRADE, IMPLEMP1 IM WHERE SAL BETWEEN LOSAL AND HISAL AND GRADE > 3 AND E.EMPNO = IM.EMPNO(+) AND IM.IMPL = NULL;*/ /*SELECT DISTINCT P.PRONO, PRONAME FROM PROJECT1 P, IMPLPROJECT1 IP1, IMPLPROJECT1 IP2 WHERE P.PRONO = IP1.PRONO AND P.PRONO = IP2.PRONO AND MONTHS_BETWEEN(IP1.START_DATE, IP2.END_DATE) < 2;*/ SELECT ENAME FROM EMP1 E, IMPLEMP1 IE, (SELECT IMPL FROM IMPLPROJECT WHERE START_DATE BETWEEN TO_DATE('2009/01/01') AND TO_DATE('2009/03/31') AND END_DATE BETWEEN TO_DATE('2009/01/01') AND TO_DATE('2009/03/31')) IP WHERE E.EMPNO = IE.EMPNO(+) AND IE.IMPL = IP.IMPL AND IP.IMPL IN (SELECT IMPL FROM IMPLEMP1 GROUP BY IMPL HAVING COUNT(1) > 1);...