Output Records Using Joins and Union

What will be the output (Number of records) for below operators.
Table A has one column with values(1,1,2,2,2,3,4,5)
Table B has one column with values (1,1,1,2,2,3)
1. A Union B
2. A Intersection B
3. (A Union B) minus (A Intersection B)
4. A minus B
5. A Left Join B
6. A Right join B
7. A Inner join B
8. A Outer Join B
9. A Full Join B
  • Interview Candidate
  • 6
  • 5373

Showing Answers 1 - 6 of 6 Answers

Prince Jain

  • Apr 8th, 2016
 

1.12345
2.123
3.45
4.45

  Was this answer useful?  Yes

Chinmaya

  • Aug 8th, 2019
 

1.12345
2.123
3.45
4.45
5.ID ID_1
1 1
1 1
1 1
1 1
1 1
1 1
2 2
2 2
2 2
2 2
2 2
2 2
3 3
5
4
6.ID ID_1
2 2
2 2
2 2
2 2
3 3
1 1
1 1
1 1
1 1
1 1
1 1
2 2
2 2
7.inner join
ID ID_1
1 1
1 1
1 1
1 1
1 1
1 1
2 2
2 2
2 2
2 2
2 2
2 2
3 3

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions