Interested to Buy Any Domain ? << Click Here >> for more details...
what is an outer join? difference between left outer join
right outer join with an example?
- 1 Answers
- 11117 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / m m naidu
OUTER JOIN: It is used to retrieve all the rows from one
table but matched rows from another table
LEFT OUTER JOIN: It displays matched row from two tables
and unmatched row from left hand side table
EX: select a.empno,a.ename,a.sal,b.deptno,b.dname,b.loc
from emp a left outer join dept b on(a.deptno=b.b.deptno)
RIGHT OUTER JOIN: It displays matched rows from two tables
and unmatched row from right hand side table
EX: select a.empno,a.ename,a.sal,b.deptno,b.dname,b.loc
from emp a right outer join dept b on(a.deptno=b.b.deptno)
| Is This Answer Correct ? | 15 Yes | 5 No |
Post New Answer View All Answers
What you mean by drill across and what is the difference between drill through, drill across?
How to deploy from one server to another server?
What is cognos powerhouse?
Explain informatica architecture?
is there any difference between operational database and data base?if yes what r they?
What are the types of folder present in cognos?
What are the advantages of using cognos sql?
What is meant by drill down?
How to publish a package by running Java Script?
What do you understand by the term 'dynamic cube'?
Can you explain dynamic query mode?
Can you define pivot?
What do you understand by the term 'aggregate cache'?
What are the types of catalogs in cognos?
What DB View and Bus View?
