What are joins..how many types of joins are there?
- 29 Answers
- 76742 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
How translate command is different from replace?
Explain the difference between sap and oracle?
ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process
What are the data types in oracle?
Is it possible to insert comments into sql statements return in the data model editor ?
How to assign values to data fields in record variables?
What is merge in oracle?
How to login to the server without an instance?
Explain oracle’s server parameter file.
How do I know if oracle client is installed on windows?
What is data type in oracle?
Explain a data segment?
How to create a stored function in oracle?
What is a dead lock in oracle?
How to create lov dynamically at runtime & attach to text field?
