Submitted Questions

  • 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

    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

    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)