please anyone explain the equi join,outer joi(right outer
join and left outer join),theta join and self join with
database tables.
Answer Posted / babu
Equai join: Matching records based on equality condition is
satisfied in the both the tables.
Left puter jion:All Records from left table only matcning
records form right table.
Right outer join:All records from right table and only
mating rows from left table.
theta join:Mating the records based on other than the
euality(ex:Age,Marks)
Self Join:It's a join with itself is called self join
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?
Explain about a task that really tested your analytical abilities?
can anybody tell me about complicated object you have created
hi all of u, i want to learn the course in SAP(BI).because of there is no calls for BO. And the another region is it will be converted into SAP module. is it OK for me? is there any feauture in coming days? could any one plz send me the message
Is there any other repository domains rather than universe, security, document?
How to create Index to the table in the universe designer and how it improves the Query performence
What is the dense rank?
What Is The Difference Between Oltp And Olap?
Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?
what is universe null
How we drill up week to month?
How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes
What are all difference between business objects 6.5 and xi r2?
8. How much supervision have you typically received in your previous job?
Explain the difference between union and group?