explain different types of jions with examples briefly?
- 2 Answers
- 7999 Views
- Accenture, Excellence, Zensar, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is the tcp/ip port on which sql server runs?
How do you start single user mode in clustered installations?
What is query optimization process?
What part does database design plays a role in performance of an sql server-based application?
What are triggers in ms sql server?
How to create a stored procedure with a statement block in ms sql server?
How to recover from sql injection? : sql server security
How data can be copied from one table to another table?
What are the various editions of sql server 2017 that are available in the market?
What are the advantages of having an index on the sql server?
What does it mean to manipulate data?
Explain datetime2 data type in sal server 2008?
Tell me about builtinadministrator?
why would you use sql agent? : Sql server database administration
Do you know what is raid and what are different types of raid configurations? : SQL Server Architecture
