Interested to Buy Any Domain ? << Click Here >> for more details...
explain different types of jions with examples briefly?
- 3 Answers
- 10424 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 are indexes in ms sql server?
Explain nested trigger in sql?
What is logshipping and its purpose?
Explain error and transaction handling in sql server?
How to use subqueries in the from clause in ms sql server?
do views contain data ?
How do I schedule a sql server profiler trace?
How to create “dependant” parameter “make, model, year”
What is data modeling and Reterminal integrity?
Explain few of the new features of sql server 2008 management studio
What are the different types of Indexes available in SQL Server?
What are the advantages of partitioning?
Explain insert into select statement?
How to rebuild all indexes on a single table?
What is data source view or dsv? : sql server analysis services, ssas
