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

Which joins are sql server default?

1006

How to make a column nullable?

1109

How to create median function?

164

Where actually sql azure database is hosted?

163

What is the fillfactor concept in indexes?

980

What do you mean by SQL injection attack?

1057

How does index makes search faster?

971

how to create “alternate row colour”?

146

What is the name of reporting services config file and what’s it’s used for?

146

How to execute stored procedure in select statement sql server?

1055

How to encrypt data between dialogs?

1105

Write a SQL query in order to merge two different columns into single column?

1033

What is the command dbcc checkdb used for?

1010

Is it possible to have clustered index on separate drive from original table location?

962

explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

1054