Solution : a) 40 rows b) 40 rows c) 40 rows http://abhishekgaikwadt

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

Question Posted / abhishek6555

2 Answers
4948 Views
Synechron, TCS, I also Faced
E-Mail Answers

Answer Posted / abhishek6555

Solution :

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

http://abhishekgaikwadtech.blogspot.in/2015/07/t-sql-interview-question-2.html

Is This Answer Correct ?

14 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is use of dbcc commands?

1071

When to use null data driven subscription?

206

what is the system function to get current user's user id? : Sql server database administration

1000

How can I know what locks are running on which resource?

957

How do I find the size of a sql server database?

928

Why are sql functions used?

1118

What method is used by the Command classes to execute SQL statements that return single values?

1066

What are cursors stored procedures and triggers?

1019

What is analysis service repository?

1023

Explain how to use linked server?

991

What is mssql?

985

Differentiate between a local and a global temporary table?

954

What are the dmvs?

1014

What is the difference between for auto and for nested?

1001

What is raiseerror? What is raiseerror?

1141