Interested to Buy Any Domain ? << Click Here >> for more details...
please anyone explain the equi join,outer joi(right outer
join and left outer join),theta join and self join with
database tables.
- 2 Answers
- 6390 Views
- Wipro, I also Faced
- E-Mail Answers
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
Explain what is the difference between business requirement document and use case document.
How to restrict password to a user while sending a document in .pdf format
Explain what sort of existing documents should business analysts refer to when starting on a new project?
What is difference between webi and infoview?
Explain how we drill up week to month?
Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?
how to create metric universe ?
Which command using Query Analyzer will give you the version of SQL server and operating system ?
What is the difference between user and versatile user?
Explain what is the difference between slice and dice and cross tab report?
What is difference between custom hierarchy and report based hierarchy?
Explain how can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?
What is a fantrap in business objects?
What Is Snow Flake Schema?
Can we configure two instances of CMS pointing to two different CMS system databases?
