Interested to Buy Any Domain ? << Click Here >> for more details...
explain different types of jions with examples briefly?
- 3 Answers
- 10477 Views
- Zensar, I also Faced
- E-Mail Answers
Answer Posted / dinesh .
16)Join
Table1:Record
1 a
2 b
3 b
4 b
4 c
Table2:Record1
1 a 2
2 b 2
3 c 24
5 f 2
8 g 2
10 j NULL
Inner Join:
Qry1:select record_name,recordcount from record inner join
record1 on
record.record_id=record1.record_code
Result:
a 2
b 2
b 24
qry2:select p.record_name,q.recordcount from record p,
record1 q where p.record_id=q.record_code
Result:
a 2
b 2
b 24
Left Join
qry3:select record_name,recordcount from record left join
record1 on
record.record_id=record1.record_code
Result:
a 2
b 2
b 24
b NULL
c NULL
Right Join
qry4:select record_name,recordcount from record right join
record1 on
record.record_id=record1.record_code
Result:
a 2
b 2
b 24
NULL 2
NULL 2
NULL NULL
Left Outer Join
qry5:select record_name,recordcount from record left outer
join record1 on
record.record_id=record1.record_code
Result:
a 2
b 2
b 24
b NULL
c NULL
Right Outer Join
qry6:select record_name,recordcount from record right outer
join record1 on
record.record_id=record1.record_code
Result:
a 2
b 2
b 24
NULL 2
NULL 2
NULL NULL
Full Outer Join
qry7:select record_name,recordcount from record full outer
join record1 on
record.record_id=record1.record_code
Result:
a 2
b 2
b 24
b NULL
c NULL
NULL 2
NULL 2
NULL NULL
"Their is No Left Inner Join,Right Inner Join in SQL Server
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
How to create a store procedure with encryption?
Tell me what is de-normalization and what are some of the examples of it?
What is SQL Azure Federations?
What is log shipping?
What are three major types of constraints?
What is sql language?
What is log in sql server?
Explain the etl (extraction, transformation, and loading)?
What encryption security is available in sql azure?
what are the disadvantages of cursors? : Sql server database administration
What is the parse query button used for?
Explain what are sparse columns?
What are the types of indexing?
What are the advantages of paper records?
Give an example of why you would want to denormalize a database
