[DB] 09. 03. 16 - CH3 기본적인 SELCT문 & CH5 함수
CH3 기본적인 SELCT문 SQL> ed file afiedt.buf(이)가 기록되었습니다 1 select e.ename, d.dname, e.sal 2 from emp e, dept d 3* where e.deptno = 30 and sal >= 1500 and e.deptno = d.deptno SQL> / ENAME DNAME SAL ---------- -------------- ---------- ALLEN SALES 1600 BLAKE SALES 2850 TURNER SALES 1500 SQL> ed file afiedt.buf(이)가 기록되었습니다 1 select e.ename, e.deptno, d.dname, e.sal 2 from emp e, dept d 3* where e.deptno..