what are the different types of joins?
Answers were Sorted based on User's Feedback
Answer / a.jyothsna
1)Self Join
2)Equi join (or)Inner Join
2.1)Non-equi Join
3)Outer Join
3.1) Left-Outer Join
3.2) Right-Outer Join
3.3) Full-Outer Join
| Is This Answer Correct ? | 14 Yes | 0 No |
Answer / desiraju venkata subramanya ka
types of joins
• outer join
• left join
• right join
• equi-join
• non-equi-join
• selfJoin
| Is This Answer Correct ? | 7 Yes | 2 No |
Answer / prakash
Proprietary Joins
----------------
EquiJoin
Non EquiJoin
Self Join
outer join
Compliant Joins
---------------
Cross Join
Natural Joins
Full or two sided outer joins
Arbitrary Joins
| Is This Answer Correct ? | 0 Yes | 1 No |
How to fetch alternate records from a table?
Is merge a dml statement?
What is the difference between delete and truncate commands?
how to concatenate two character strings? : Sql dba
What are all the different normalizations?
give the syntax of grant and revoke commands? : Sql dba
How do I find duplicates in sql?
How can I tell if sql is running?
display your age in months?
what is meant by urlencode and urldocode? : Sql dba
What is sql dialect?
What is trigger explain it?
Oracle (3253)
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)