Interested to Buy Any Domain ? << Click Here >> for more details...
explain different types of jions with examples briefly?
- 2 Answers
- 8998 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 are the difference between clustered and a non-clustered index?
You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?
Explain hostprotectionattribute in sql server 2005?
Explain the different index configurations a table can have?
What is exclusive locks?
Explain few of the new features of sql server 2008 management studio
Do you know what are various aggregate functions that are available?
Ms sql server index?
What are cascading parameters in ssrs reports?
What is update locks?
What is sub query and its properties?
how you can configure a running aggregate in SSRS?
What types of replication are supported in sql server?
‘Order by’ is not allowed in a view how can you sort information from a view?
How to copy the tables, schema and views from one sql server to another?
