SQL output interview question

Question

There are two tables X and Y and each have one column

X    Y

1      1

1       1

1      1

1

1

How many rows will be populated if we do a

– right join

– left join

– cross join

– inner join

in progress 3
Xtramous 55 years 2 Answers 1399 views Contributor 0

Answers ( 2 )

  1. 15 in all the cases.

  2. 15 rows in all the 3 cases

  3. 15 everytime

  4. – right join : 15

    – left join : 15

    – cross join: 15

    – inner join: 15

Leave an answer

Browse
Browse