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
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
What is use of dbcc commands?
When to use null data driven subscription?
what is the system function to get current user's user id? : Sql server database administration
How can I know what locks are running on which resource?
How do I find the size of a sql server database?
Why are sql functions used?
What method is used by the Command classes to execute SQL statements that return single values?
What are cursors stored procedures and triggers?
What is analysis service repository?
Explain how to use linked server?
What is mssql?
Differentiate between a local and a global temporary table?
What are the dmvs?
What is the difference between for auto and for nested?
What is raiseerror? What is raiseerror?