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
- 63700 Views
- DELL, i Tech, Infosys, Siemens, TCS, I also Faced
- E-Mail Answers
Answer Posted / j.jyothy
Already i explained 3 joins now i tell u Outerjoins.
leftouterjoin:It will display all the rows of left table
irrespective of whether there is a match in the right or
not.If there is no match in the right table then the null
row is aasumed and it is displayed in the output.
Display all emps in the emptable.
select empno,ename,esal,e.deptno,d.deptno,dname,loc from
emp e left outerjoin dept d on e.deptno=d.deptno
RightOuterJoin:It will display all the rows of right table
irrespective of whether there is a match in the right or
not.If there is no match in the Left table then the null
row is aasumed and it is displayed in the output
Example
select empno,ename,esal,e.deptno,d.deptno,dname,loc from
emp e right outerjoin dept d on e.deptno=d.deptno
| Is This Answer Correct ? | 23 Yes | 18 No |
Post New Answer View All Answers
Explain the first normal form(1nf)?
How to use “drop” keyword in sql server and give an example?
What is blocking?
Can sql server be linked with other servers like oracle?
Explain “not null constraint” in sql server?
write an SQL query to list the employees who joined in the month of January?
Tell me what are the advantages of using stored procedures?
How to use go command in "sqlcmd"?
Should you normalize audio?
What are the types of user defined functions in sql server?
How to get a list of columns using the "sys.columns" view in ms sql server?
In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram
Tell me what is the order in which the sql query is executed?
Explain indexing and what are the advantages of it?
What is sql server management studio? : sql server management studio
