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
- 2 Answers
- 4010 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
Explain what is meant by replication of database?
How to change parameter value inside the report?
How to create function with parameter in sql server?
your distribution database is full what will u do
Why does sql studio use a single registered database repository? : sql server management studio
Define compound operators?
How sql server enhances scalability of the database system?
List some major differences between triggers and stored procedures?
What is sql server 2000 work load governor?
What is executereader?
Data is not being delivered to subscribers, what can be the possible reasons? : sql server replication
What is difference between joins and subqueries?
As per your opinion what are the five top responsibilities of a dba? : sql server database administration
Distinguish between commit and rollback?
What happens if ntwdblib.dll is missing on your machine?
