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
- 10944 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
Tell me about Dnamic and Static Dashboards?
Cleared COG-112 with 100% score today. What next certification should i go for?
What is the difference b/w macros and prompt?
What is the difference between a cascading report and drill through report?
Can you define drill across?
What is a Framework manager?
How can create users and permissions in cognos?
What are all the types of report?
Define the cognos reporting tool?
whats the difference between previous version of cognos and cognos 8 BI?
What is the difference between set functions and filter function in dimensional data?
What is cognos connection?
What is the difference between regular dimension and derminant?
Actually we have 500 users when they run the report display the flage image related country user? How its possible?
what is the use of backward drilling in cognos 8?is it possible?whats the uws of it?
