Interested to Buy Any Domain ? << Click Here >> for more details...
explain different types of jions with examples briefly?
- 3 Answers
- 10471 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 factless fact table? : sql server analysis services, ssas
How to concatenate two character strings together?
How many levels of sp nesting is possible?
Can you edit the .rdl code associated with a linked report?
what are the steps you will take to improve performance of a poor performing query? : Sql server database administration
What are the advantages to use stored procedures?
What program is used to store the data source file?
What happens if an integer is too big for int date type?
What is the minimum and maximum number of partitions required for a measure group? : sql server analysis services, ssas
What is indexed view?
How many partitions a clustered index has by default in sql server 2012?
What is the difference between set and select?
What is a unique index?
How do I find the default sql server instance?
What happens if strings are casted into wrong code pages in ms sql server?
