Thursday 23 July 2015

T-SQL interview question 2

2) Consider a Table name A which has below records

ID
---
5
5
5
5
5
Consider another table B which has below records

ID
--
5
5
5
5
5
5
5
5
How many rows will be returned by each of the below queries
a) select * from A inner join B on A.id = b.ID
b) select * from A left join B on A.id = b.ID
c) select * from A right join B on A.id = b.ID

Solution :

a) 40 rows
b) 40 rows
c) 40 rows


No comments:

Post a Comment