explain different types of jions with examples briefly?
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
You accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover?
Can we add an identity column to decimal datatype?
When to use null data driven subscription?
what is bit datatype? : Sql server database administration
What is history table in sql server?
If you lose rights to your sql server instance what are the options to connect to sql server instance? : sql server security
What happens if null values are involved in datetime operations?
What is the difference function and stored procedure?
What is measure group, measure? : sql server analysis services, ssas
What is the web service used for reporting services?
How to count rows with the count(*) function in ms sql server?
What is indexing in sql server with example?
What is the difference between varchar and varchar(max) datatypes?
What is built-in function?
What is outer join in sql server joins?