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
- 63779 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
Do you know what are various aggregate functions that are available?
What is a select query statement in ms sql server?
How to delete all rows with truncate table statement in ms sql server?
tell me what is blocking and how would you troubleshoot it? : Sql server database administration
How does normalization work?
What is merge replication?
What extended events?
What is 2nf example?
Do you know what is difference between stored procedure and user defined function?
Tell me the phases a transaction has to undergo?
How to install sql server 2005 express edition?
Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.
What is difference between rownum and row_number?
What is multi-statement table-value user-defined function?
Can one drop a column from a table?
