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
- 63365 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
I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration
Can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible?
What are rows and columns?
What is the recommended total size of your memory optimized tables?
What is repeatable read?
How do I edit a stored procedure in sql server?
What do you understand by triggers and mention the different types of it?
What is SubQuery in SQL Server 2008
What is tablesample?
Explain about analysis services?
What is openxml in sql server?
How to get a list all databases on the sql server?
What are data resources?
How to delete an existing database user?
What are the difference between primary keys and foreign keys?
