Output (Number of Records) using Joins and Union

What is the output (number of records)?
Table A with one column values (1,1,2,2,2,3,4,5)
Table B with one column 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 Inner Join B
6. A Left Join B
7. A Right Join B
8. A Full Join B
9. A Outer Join B

Questions by minnu

Showing Answers 1 - 2 of 2 Answers


  • May 29th, 2016

1. Union:(1,1,2,2,2,3,4,5)
2. Intersection:(1,1,2,2,3)
3. ::(2,4,5)
4. Aminus b:(2,4,5)

  Was this answer useful?  Yes


  • Mar 1st, 2017

a union B : 1,2,3,4,5
a intersection b:1,2,3
a union b minus a intersection b :4,5
a minus b : 4,5
a inner join B :1,1,1,1,1,1,2,2,2,2,2,2,3
a left join b :1,1,1,1,1,1,2,2,2,2,2,2,3,4,5
a right join b :1,1,1,1,1,1,2,2,2,2,2,2,3
a full join b :1,1,1,1,1,1,2,2,2,2,2,2,3,4,5

  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