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
Answers were Sorted based on User's Feedback
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 |
Answer / swetha
40 rows but using cross join we can get no of rows
Is This Answer Correct ? | 1 Yes | 0 No |
How to find the service pack installed? : sql server database administration
What is a collation?
What is the difference between grant and with grant while giving permissions to the user?
How to move database physical files in ms sql server?
What is an execution plan? How would you view the execution plan?
what is the different types of backups available in sql server? : Sql server database administration
What is data integrity? Explain constraints?
Mention the uses of stored procedures.
Explain transaction isolation levels in sql server?
What is the command used to get the version of sql server?
How to get nth highest salary from employee table.
How many types of dimensions are there and what are they? : sql server analysis services, ssas