Interested to Buy Any Domain ? << Click Here >> for more details...
what is outer join?
what is selef join?
what is difference between them?
what is cartecion join?
- 1 Answers
- 11222 Views
- Fiserv, Herbinger, Synechron, I also Faced
- E-Mail Answers
Answer Posted / nandini sett
Outer join displays result set containing all the rows from
one table and the matching rows from another table. There
are three types of Outer Join -- Left Outer Join (All rows
of the left table and matchng rows of the right), Right
Outer Join (All rows of the right table and matching rows
of the left table) and Full Outer Join (All rows of both
tables).
In self join, table is joined with itself. One row
correlates with other rows in the same table. Hence a table
name with two alias names is used.
Difference between outer join and self join is that outer
join uses atleast two or more tables where one column is
common while self join uses only one table and two fields
of the same table.
Cartesian Product or cross join is between two tables where
each row from one table with each row of the other table.
If table A has 5 rows and table B has 10 rows then after
cross join the total number of rows would be 50.
| Is This Answer Correct ? | 43 Yes | 1 No |
Post New Answer View All Answers
What is a function in oracle pl sql?
What is the use of index in sql?
how to create a new table in mysql? : Sql dba
Is id a reserved word in sql?
How can you get sql*loader to commit only at the end of the load file? : aql loader
Is vs as in pl sql?
How do I partition a table in sql?
What is the difference between cross join and natural join?
What are database links used for?
how to select first 5 records from a table? : Sql dba
Why do we use function in pl sql?
What are few of the schema objects that are created using PL/SQL?
What is the difference between cluster and non-cluster index?
what is a scheduled jobs or what is a scheduled tasks? : Sql dba
What is the difference between jpql and sql?
