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 |
How to run queries with sql server management studio express?
Is sql server free?
What is user defined stored procedures?
how you can get the list of largest tables in a database? : Sql server administration
how to control the amount of free space in your index pages? : Sql server database administration
Determine when an index is appropriate?
What is a cursor in SQL Server 2000 and their types?
What are the source of constraints?
Define self join?
How to run sql server 2005 books online on your local system?
How do I find the transaction log size in sql server?
What are some of the pros and cons of not dropping the sql server builtinadministrators group? : sql server security