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

You want to generate a report that is formatted as a chart. Can you use the report wizard to create such a report?

115

Explain sql server service broker?

925

Can we perform backup restore operation on tempdb? : sql server database administration

945

Do you know the policy based administration feature of sql server 2008?

905

How can a database be repaired?

923

If you are given access to a SQL Server, how do you find if the SQL Instance is a named instance or a default instance?

1040

What do you mean by sql server agent?

942

What are the essential components of sql server service broker?

964

what is database replication? : Sql server database administration

986

How to define and use table alias names in ms sql server?

1042

What do you think of this implementation? Can this be implemented better?

875

Difference between primary key and clustered index?

933

What is policy management?

933

What types of replication are supported in sql server?

997

Why use update_statistics command in sql server?

999