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
- 4404 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
role of sql sever 2005 in database rather than any other database
What are the differences between DDL, DML and DCL in SQL?
What is meant by dirty read?
What are window functions in sql server?
How to create a simple stored procedure in ms sql server?
Tell me can we use custom code in ssrs?
Where sql server user names and passwords are stored in sql server? : sql server database administration
What will be the value of @@fetch_status if a row that was a part of the cursor resultset has been deleted from the database after the time the stored procedure that opened the cursor was executed?
How to make a column nullable?
What are click through reports?
Name the different type of indexes in sql?
What is role playing dimension with two examples? : sql server analysis services, ssas
What command do we use to rename a database?
How to rename databases in ms sql server?
What is ssl in sql server?
