explain different types of jions with examples briefly?
Answers were Sorted based on User's Feedback
Answer / hari
Inner join
outer join--left outer join ,right outer join , full outer
join
Cross Join
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / soni
Inner join: This type of join displays matched rows from
tables.
this is based on equality condition ,so also called
equijoin.
exp- select empid,d.deptid,deptname,empname,location,salary
from emp e inner join dept d on e.deptid=d.deptid
Cross join: this is not based on any condition. It results
every row of one table matching with every row of another
table.
exp- select * from emp cross join dept
Self join: This ype of join joins a table to itself.
outer join:
Three types -
a.left outer join: It reults mathed rows from both tables
as well as all unmatched rows from left table.
exp- select empid,d.deptid,deptname,name,location,salary
from emp e left outer join dept d
on e.emp=d.dept
it displays all data from emp table .
right Outer join:It reults mathed rows from both tables as
well as all unmatched rows from right table.
exp- select empid,d.deptid,deptname,name,location,salary
from emp e right outer join dept d
on e.emp=d.dept
it displays all data from dept table .
Full Outer Join: This type of join results all matched
rows from both tables as well as umatched rows from both
tables.
exp.-select empid,d.deptid,deptname,name,location,salary
from emp e full outer join dept d
on emp e=d.dept d
It displays all matched and unmatched rows from both emp
and dept tables.
Is This Answer Correct ? | 5 Yes | 3 No |
Does sql server use t sql?
What is surrogate key? : sql server analysis services, ssas
How adventureworkslt tables are related?
What is the recursive stored procedure in sql server?
In the primary key have a multiple field or not?
How do I get to sql server configuration manager?
Is sql server implemented as a service or an application? : Sql server database administration
What is an extended stored procedure? Can you instantiate a COM object by using T-SQL?
what is diffence between replicaion and logshipping?
you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration
What does it mean if @@cursor_row returns a negative number?
Explain index in sql server?