Interested to Buy Any Domain ? << Click Here >> for more details...
explain different types of jions with examples briefly?
- 3 Answers
- 10313 Views
- Zensar, I also Faced
- E-Mail Answers
Answer Posted / ramesh
Basically Joins are used to get result from two or more
tables and there are two types of joins
inner join and outer join
Inner join : a join of two or more tables which omits the
blank rows while checking
Outer join is subcatogorised in to left outer join and right
outer join. Which includes blank rows in specifed side if
condition satisfies.
Simple outer join is combination of left and right outerjoins.
Apart from these there are
Natural join : cartisian product
Equi join : which includes = operator in condition
NonEqui join : All conditional joins which doesn't uses = in
there conditions.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
what is a join and explain different types of joins? : Sql server database administration
What do you mean by recursive stored procedure?
How to call stored procedure using http soap?
State a few properties of relational databases?
How do I run sql server 2014?
Is sql server implemented as a service or an application? : Sql server database administration
What is inner join in sql server joins?
What is resource governor in sql server?
Tell me what do we need queues in sql service broker?
Explain datetime2 data type in sal server 2008?
what is raid and what are different types of raid configurations? : Sql server database administration
Relational calculus is what type of language?
Which are the olap features?
What is the function of inner join?
What is the significance of null value and why should we avoid permitting null values?
