Types of joins ?
Answers were Sorted based on User's Feedback
Answer / ramesh yadav
IN ORACLE 9i.
Equi - Join = Both are same Names only different
simple join
inner join
Natural join
join
Non - Equi Join
Outer Join
Left outer join
Right outer joi
Full outer join
Self join
Cartesian Product
| Is This Answer Correct ? | 9 Yes | 0 No |
Answer / bipin
sql-server
inner join
outer join
left outer join
right outer join
full outer join
cross join
oracle sql
inner join
outer join
left outer join
right outer join
full outer join
cross join
natural join
| Is This Answer Correct ? | 8 Yes | 2 No |
Answer / vinodkumar.r
2 types
1)inner join ,
2)outer join
a)left outer
b)right outer
c)full outer
| Is This Answer Correct ? | 7 Yes | 2 No |
How do you respond to dementia behavior?
What are the parts of a basic sql query?
What is the difference between sql and mysql?
How many types of functions are there in sql?
Are null values same as that of zero or a blank space?
can we create index on index?
Why functions are used in sql?
what are all the different types of indexes? : Sql dba
What is a primary key, and how is it different from a unique key?
Can 2 queries be executed simultaneously in a distributed database system?
what are the security recommendations while using mysql? : Sql dba
How to execute multiple sql statements in a single annonymous block irrespective of the sql statement result?
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)