⇒ Her bir rowun sadece bir defa gЎr№lebilmesi iчin
9vhyvtÃ9hhÃA ÃHyvyrÃUhiyrà 7øS9@IÃA6aG6ÃU67G@96IÃ96U6ÃTPSBVG6H6FÃ#à SELECT SELECT SELECT Bvqryvrà ç ç ç table1.coulmn, table2.column FROM table1, table2 emp.ename, emp.deptno, dept.deptno, dept.dname FROM emp, dept emp.ename, emp.deptno, dept.deptno, dept.dname FROM emp, dept WHERE empno = 7788 Uhiyryh qhxvÃià yh ÕÃt|r v Ã8h rvhà qpÃúÃq yh qhÃhyÕÕ SELECT table1.coulmn, table2.column FROM table1, table2 WHERE table1.column conditional_operator table2.column SELECT table1.coulmn, table2.column FROM table1, table2 WHERE table1.column = table2.column SELECT SELECT emp.empno, emp.ename, emp.deptno, dept.deptno, dept.loc FROM emp, dept WHERE emp.deptno = dept.deptno emp.empno, emp.ename, emp.deptno, dept.deptno, dept.loc FROM emp, dept WHERE emp.deptno = dept.deptno AND INITCAP(emp.ename) = ‘King’ Equijoin Joinler Cartesian Product Ihrà Additional Search Condition ørr rxà #ÃYÃ#Ã2Ã$%à Ãt|r v EvÃúh ÕÃvuhyÃrqvyv r EvÃúh ÕÃtror yvÃqr÷vyr Sonuç olarak tablr ÃvyrÃhiyr!ÃvÃiÃxhÕyh ÕÃrx hqhÃiv yrúv • 7v Ãph rvhà qpÃq÷ ÃXC@S@ÃpyhryhÃxyyhÕyÕ hÃwvÃryqrÃrqvyv • ColmnlarÕÃihúÕhÃhiyrÃvvyr vvÃrxyrrvÃr s hÕÃh Õ Õ • IÃhiyrÕÃwvÃrrxÃvovÃIÖà ÃwvÃúh ÕÃtr rxv Ã7Ãx hyÃÃpvrà vh à keyler için geçerli olmayabilir • UhiyrÃpyyh ÕqhÃiv vyrÃihúxhÃiv ÃÃhiyrÃpyÃrúvyrrvqv • Q vh ÃrÃA rvtÃFryr ÃwvÃrhÕqhÃr s hÕÃh Õ Õ Detail Master EMP DEPT Join Condition EMPNO SELECT DEPTNO DEPTNO Foreign Key Primary Key .empno, r.ename, r.deptno, q.deptno, q.loc FROM emp r, dept q WHERE r.deptno = q.deptno r Outer Join Non- Equijoin • UhiyrÃhyvhyh Õà ÃvyrÃ"ÃøtvyvÃuh svÃh hÕqhÃyhivyv • FÕhÃhyvhyh ÃTRGÃxqÃuhsÕhqhÃqhuhÃhÃr ÃxhyhhÕÕÃh÷yh • UhiyrÃhyvhyh ÃhqrprÃxyyhÕyqÕ÷ÕÃTRGÃhrrÕÃvovÃtror yvqv • UhiyrÃpyyh ÕqhÃiv vyrÃihúxhÃiv ÃÃhiyrÃpyÃrúvyrrrsidir SELECT SELECT SELECT SELECT table1.coulmn, table2.column FROM table1, table2 WHERE table1.column BETWEEN | <= | >= table2.column e.ename, e.sal, s.grade FROM emp e, salgrade s WHERE e.sal BETWEEN s.losal AND s.hisal table1.coulmn, table2.column FROM table1, table2 WHERE table1.column = table2.column(+) emp.empno, emp.ename, emp.deptno, dept.deptno, dept.loc FROM emp, dept WHERE emp.deptno(+) = dept.deptno ç Her bir rowun sadece bir defa görülebilmesi için * (PS¶GHNL KLoELU URZXQ 6DO GH÷HUL 6DOJUDGH¶GHNL HQ NoNWHQ küçük, en büyükten de büyük olmamasÕ JHUHNLU * 6DOJUDGH WDEOHÕQGDNL /RVDO +LVDO GH÷HUOHULQGHQ KLoELUL ELUELUL\OH oDNÕúPDPDOÕGÕU • @vwvyr qrÃrúvyv÷rÃxh úÕyÕxÃtryrrÃhÕ yh ÕÃt|r v • SÃxh úÕyÕ÷ÕÃrxvxÃyhÃhiyrÃvvvÃhÃÃvúh rvÃx • Pr ÃEvÃúh yh Õ ÃÃvúh rvÃhqrprÃrúvyv÷vÃiv Ãh hsÕhÃxhivyv ÃXC@S@ÃpyhrqhÃPSÃih÷yhpÕÃrÃDIÃr h| ÃxyyhÕyhh Self Join • UhiyrqhxvÃpyyh qhÃiv vvÃhÕÃhiyrqhxvÃihúxhÃiv Ãpyà rsr hs etmesi SELECT EMP worker.ename || ‘ works for ‘ || manager.ename FROM emp worker, emp manager WHERE manager.empno=worker.mgr EMPNO
© Copyright 2024