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
- 6476 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / punnaiahbabu
Equi join means equlity condition b/w tables
left outerjoin :matching and unmatching from left side onley
matched from right side.........
right outer join:matching and unmatching from right side
onley matched from left side.
outer join :matching and unmatching displed both of the tables
self join:we will right on sql query on the table.
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
What is the difference between condition & filter?
Explain what would you consider as your biggest achievement and why?
Can we configure two instances of CMS pointing to two different CMS system databases?
What three things do you consider to be the most important factors for a manager?
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)?
any difficulitis have you phase while creating bo reports and how did u solve it
What are the data types present in bo? What happens if we implement view in the designer and report?
Which command using Query Analyzer will give you the version of SQL server and operating system ?
How to execute the plsql procedure from the report by clicking with mouse?
What Is Snow Flake Schema?
1)I have createcd a dashboard on Bex query. How to refresh the Dashboard without hitting the bex query? 2)What is Event based scheduling in BO? 3) How to display the BO webi report title using a function? 4) For eg in my webi report iam having a person name like Jhon Peter Adam. But i need to get only the middle name of the person like Peter. What function is used in Webi to get this?
What is the difference between absolute and relative div positioning?
Can Bo generates the Report from the cubical data Explain?
What we need to discuss with designer before starting the universe designing.
What is top business?
