Interested to Buy Any Domain ? << Click Here >> for more details...
explain different types of jions with examples briefly?
- 3 Answers
- 10591 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 the use of keyword with encryption. Create a store procedure with encryption?
How to enable tcp/ip protocol on a sql server?
What are data driven subscriptions?
Mention the different authentication modes in sql server.
Is it possible to run multiple publications and different type of publications from the same distribution database? : sql server replication
How to loop through result set objects using odbc_fetch_row()?
How can we solve concurrency problems?
What is openxml in sql server?
Mention the differences between sql server and mysql.
Explain throw statement in sql server 2008?
What is executereader?
What are the requirements to use odbc connections in php scripts?
Define msdb database?
What is change tracking in sql server?
what is the difference between Delete and Truncate command in SQL
