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 |
what is a database transaction? : Sql dba
Explain the purpose of %type and %rowtype data types?
What is an escape character in sql?
What is pragma in sql?
What is server name sql?
oracle is compiler or interpretter,can any one tell me the answer?
How to retrieve a second highest salary from a table? Note:Suppose salaries are in duplicate values eg: Name Sal Malli 60000 Pandi 60000 Rudra 45000 Ravi 45000
10 Answers Mind Tree, Polaris, Sonata,
what is called after appearing where clause
What is pl/sql table? Why is it used?
What is not equal in sql?
What is normalization ?
9 Answers BirlaSoft, CTS, HCL,
..........refers to the disk mirroring
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)