Interested to Buy Any Domain ? << Click Here >> for more details...
What are the all different types of Joins in SQL Server
2000, Anybody can explain each join with definition..Thanks
in advance....
- 9 Answers
- 63702 Views
- DELL, i Tech, Infosys, Siemens, TCS, I also Faced
- E-Mail Answers
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 mean by clustered index and non clustered index, give syntax of creation? : sql server database administration
What is difference between sql and sql server?
Explain how you can configure a running aggregate in SSRS?
What is sql injection and why is it a problem? : sql server security
What is the maximum size of column in sql server?
Do you know what are the properties of the relational tables?
Why should one not prefix user stored procedures with ‘sp_’?
What is the current limitation of the size of SQL Azure DB?
How to drop an existing table with "drop table" statements in ms sql server?
Define the one-to-one relationship while designing tables.
Explain index in sql server?
List out the differences between the clustered index and non-clustered index in sql server?
What is abstracting periodical?
You are doing log shipping due to some reasons it is failing. How you will proceed from there
Can we call stored procedure in trigger?
