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

Showing Answers 1 - 1 of 1 Answers

Prince Jain

  • Apr 8th, 2016


  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