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

minnu
Profile Answers by minnu Questions by minnu
Mar 16th, 2016
6
5568

Questions by minnu

Data Warehousing

Answer

Showing Answers 1 - 6 of 6 Answers

ram

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)

shaili

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