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
5064 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 do you understand by a stored procedure?

1154

If the job running very slow what is the action you do

1942

What is the largest component inside a field?

1192

Explain different backup plans?

1007

What the difference between UNION and UNIONALL?

1091

What is relationship? What number of sorts of relationship are there?

1224

What is collation sensitivity? Explain different types.

1056

What are the advantages of using cte?

1076

What is a transact-sql statement?

1131

explain databases and sql server databases architecture? : Sql server database administration

1015

Other than truncate statement, which other command can by-pass the trigger on the tables?

1193

List out the differences between global and local temp tables in sql server?

1113

Describe the left outer join & right outer join. : sql server database administration

1037

Can you explain different types of joins?

991

Explain indexed views?

1031