Interested to Buy Any Domain ? << Click Here >> for more details...
What are joins..how many types of joins are there?
- 29 Answers
- 97171 Views
- Amdocs, CSC, TCS, I also Faced
- E-Mail Answers
Answer Posted / shree
In SQL Server,Join actually puts data from two or more
tables into a sinle result set.
there are 3 types of joins
1.Inner join
2.Outer join
3.Cross join
In Oracle server
1. Equi Join
2.Non Equijoin
3.outer joins
4.self joins
| Is This Answer Correct ? | 47 Yes | 16 No |
Post New Answer View All Answers
What happens if the update subquery returns multiple rows?
What are the benefits of ordbms?
How to set up autotrace for a user account?
Can multiple cursors being opened at the same time?
What is enter substitution variable in oracle?
Hi Can any one tell me what are the API's used in requisition import.
What is object data modeling?
What are the various oracle database objects?
What is Library Cache in Oracle?
Point the difference between translate and replace?
Explain what are synonyms used for?
What is the data type of dual table?
What is index-organized table in Oracle?
What is the relation of a user account and a schema in oracle?
What's dateware house and what's clustor with practicle example
