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
What languages bi uses to achieve the goal?
Is it ok to shrink transaction log?
What type of locking occurs during the snapshot generation? : sql server replication
What are key constraints?
Explain an automatic checkpoint
explain different levels of normalization? : Sql server database administration
Tell me what is the difference between locking and multi-versioning?
If a user does not have permission to a table, but has permission to a view created on it, will he be able to view the data in table?
Can we write a distributed query and get some data which is located on other server and oracle database?
Mention the different types of triggers?
Define compound operators?
Do you know what is sql injection?
Why use sub query in sql server and list out types of sub queries?
What is system stored procedures?
what is raid? : Sql server database administration