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
What is clustered index
How to disable a login name in ms sql server?
Explain syntax for viewing, dropping and disabling triggers?
What is resource governor in sql server?
How do you drop an index?
How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?
How much memory that we are using in Logshipping Concept?
What are various aggregate functions that are available?
List all types of constraints in sql server?
what is database replicaion? What are the different types of replication you can set up in sql server? : Sql server database administration
What do you mean by sql server 2005 express management tools?
What is merge statement?
what is bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration
What is meant by indexing?