Interested to Buy Any Domain ? << Click Here >> for more details...
Please explain the difference between outer join and inner
join? With examples would be appreciable..!
- 6 Answers
- 18874 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / vamsi krishna
INNER JOIN DISPLAYS ONLY THE RECORDS WHICH ARE SATISFYING
THE JOINING CONDITION,WHERE AS IN AN OUTER JOIN IT DISPLAYS
THE RECORDS WHICH ARE SATISFYING THE CONDITION AND ALSO
WHICH ARE NOT SATIFYING THE CONDITION ALSO.
FOR EXAMPLE TAKE EMP AND DEPT TABLE.
INNER JOIN QUERY:
SELECT EMPNO,ENAME,SAL,DEPT.DEPTNO,DNAME,LOC FROM EMP INNER
JOIN DEPT ON(EMP.DEPTNO=DEPT.DEPTNO)
OUTER JOIN QUERY:
SELECT EMPNO,ENAME,SAL,DEPT.DEPTNO,DNAME,LOC FROM EMP RIGHT
OUTER JOIN DEPT ON(EMP.DEPTNO=DEPT.DEPTNO).
IN INNER JOIN IT DISPLAYS ONLY 10,20 & 30 DEPARTMENTS.
IN OUTER JOIN IT DISPLAYS 10,20,30 AND 40 DEPARTMENTS.
TAKE DEFAULT TABLES FOR EXECUTION
| Is This Answer Correct ? | 39 Yes | 4 No |
Post New Answer View All Answers
How to view the data files in the current database?
How to export your connection information to a file?
How to use "in" parameter properly?
How to connect asp pages to oracle servers?
What are joins, explain all types of joins?
What is the implicit cursor in oracle?
Explain enable novalidate constraint.
Explain the use of show option in imp command.
How to create a table in a specific tablespace?
How remove data files before opening a database?
What are advantages of dateset in datastage?
how to convert .db (extention) database file into .dmp (extention ) for oracle database ?
How to use regular expression in pattern match conditions in oracle?
What do you mean by cdb and pdb in oracle 12c?
What is save point in oracle database?
