What are different types of joins ?
Answers were Sorted based on User's Feedback
Answer / amit das
1.Equi join
2.Natural Join
3.cartegian/cross/non-equi join
4.outer join(+)>>a)left outer join
b)right outer join
5.self join
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / mathan kumar
Two Type of Joins are there
1) Inner Join
2) Outer Join
In Inner join has 3 types they are as follows
a)Equi join
b)Cross Join
c)Natural Join
In Outer join has 3 types they are as follows
a)Left Outer Join
b)Right Outer Join
c)Full Outer Join
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / sreekanth
Basically there are 5 types of joins, they are
1.Equi join
2.Non-equi join
3.cartegian join
4.outer join(+)>>a)left outer join
b)right outer join
5.self join
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / t.rajesh gupta
Different types of joins are 1.self join, 2. Equi join, 3.
non-equi join 4. cross join
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / amar misra
1-Inner Join
2-Outer Join
3-Left Join
4-Right Join
5-Self Join
| Is This Answer Correct ? | 0 Yes | 0 No |
What is a unique key and primary key and foreign key?
What is meant by Materialized view?
2 Answers iGate, Marlabs, Polaris,
what are the difference between clustered and a non-clustered index? : Sql dba
Does postgresql run on the cloud?
What are all different types of collation sensitivity?
in procedure how to return a value
what is acid property in database? : Sql dba
What is a sql statement?
How to get each name only once from an employee table?
What is ttitle and btitle?
what is commit? : Sql dba
What is difference between a Cursor declared in a procedure and Cursor declared in a package specification ?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)