Please explain the difference between outer join and inner
join? With examples would be appreciable..!
- 6 Answers
- 17215 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
What is a package in oracle?
What is the quickest way to export a table to a flat file?
how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?
How to grant create session privilege to a user in oracle?
Point the difference between translate and replace?
How do we create privileges in oracle?
Explain an extent?
What is a proxy object?
How to create a new tablespace in oracle?
How to set up autotrace for a user account?
Explain mutating triggers.
What is blob datatype?
How can I see all tables in oracle?
What are the most common interview questions on ETL Testing for experience?
How to define default values for formal parameters?
