What are the all different types of Joins in SQL Server
2000, Anybody can explain each join with definition..Thanks
in advance....
Answer Posted / j.jyothy
There are 1.equijoins 2.self joins,3.Crossjoins.
4.Outerjoins->Leftouterjoin,Rightouterjoin,Fullouterjoin.
1.EquiJoins:They are also called innerjoins,In this only
matched rows are displayed to the user.
Example:
select eno,ename,sal,e.deptno,d.deptno,dname,loc from emp e
innerjoin dept d on e.deptno=d.deptno
2.Selfjoin:if the table is joined with table itself.
select distinct (e1.empno),e1.ename,e1.sal from emp e1 join
emp e2 on e1.sal=2* e2.sal(It dispalys emp deatails salary
exactly 2 times with any other emp salary)
Is This Answer Correct ? | 35 Yes | 11 No |
Post New Answer View All Answers
List the various tools available for performance tuning?
Can we use having clause without group by?
What is indexing and its types?
What is the security principal at the server level that represents your session?
What specific conditions database should meet, before you can bulk copy data into it using bcp?
how many bits ip address consist of? : Sql server database administration
what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration
What is checkpoint in sql server?
What are the difficulties faced in cube development? : sql server analysis services, ssas
Explain temporary table vs table variable by using cursor alternative?
How to delete a login name in ms sql server?
How is sql server used?
Explain the stored procedure?
What are the acid properties?
How does clustered and non clustered index work?