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
Write a query to include a constraint, to check whether the employee salary is greater than 5000?
What is difference statement and preparedstatement?
Can you type more than one query in the query editor screen at the same time?
What is the use of stored procedure?
Do you know what are acid properties?
Equi join and non equi join is possible with sql server?
What are the various Operating system files that every SQL server 2005 database has and what is the purpose.
Where views are stored in sql server?
Explain the creation and execution of a user-defined function in the sql server?
What is mean by candidate key?
Why we need sql server?
explain how to create a new schema in a database? : Sql server database administration
What do you understand by SQL*Net?
How to download and install the scaled-down database adventureworkslt?
What are the properties of the transaction?