Subquery
-
서브쿼리 Subquery프로그래밍/DBMS 2021. 8. 16.
WITH 서브 쿼리 WITH tmp AS ( SELECT b.bCode, bName, bPrice, b.pNum, pName, sDate, s.cNum, cName, qty, bPrice * qty amt FROM book b JOIN pub p ON b.pNum = p.pNum JOIN dsale d ON b.bCode = d.bCode JOIN sale s ON d.sNum = s.sNum JOIN cus c ON s.cNum = c.cNum ) SELECT bCode, bName, SUM(amt) FROM tmp GROUP BY bCode, bName; 단일 행 서브쿼리 SELECT empNo, sal FROM emp WHERE sal < (SELECT AVG(sal) FROM emp); 다중 행 ..