This will display the all matching records and the non-matching records from both tables. Ex: SQL> select empno,ename,job,dname...
Showing posts with label SQL. Show all posts
Showing posts with label SQL. Show all posts
Oracle SQL Right Outer Join example
This will display the all matching records and the records which are in right hand side table those that are not in left hand side table. E...
Oracle SQL Left Outer Join example
OUTER JOIN Outer join gives the non-matching records along with matching records. LEFT OUTER JOIN Left outer join produces ...
Cross Join | Oracle SQL Cross join example
CROSS JOIN This will gives the cross product. Ex: SQL> select empno,ename,job,dname,loc from emp cross join dept; ...
Natural Join | Oracle SQL Nature join example
NATURAL JOIN Natural join compares all the common columns. Ex: SQL> select empno,ename,job,dname,loc from emp natural jo...
NON-EQUI JOIN | Oracle Non-Equi join example
NON-EQUI JOIN A Join which contains an operator other than equal to ‘=’ in the joins condition. Ex: SQL> select empno,ena...
Subscribe to:
Posts (Atom)