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
5056 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

Please explain go command in sql server?

1107

How to assign null values to variables or columns?

1025

Is mysql the same as sql server?

1026

How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?

1054

What are the different types of data sources in ssrs?

201

What is the usage of the sign function?

1187

What is db stored procedure?

939

Does any body please help me what question's have asked for SSRS in the interview?

2201

Is it true, that there is no difference between a rule and a check constraint?

1107

What is a user-defined function in the sql server and what is its advantage?

1135

whats new about truncate in sql server 2008?

2549

What are the different types of replication are there in sql server 2000?

1085

Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?

2549

How do I uninstall sql server 2014?

980

What is for xml in sql server?

1131