Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 4954 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
How is SQL Azure different than SQL server?
How can we determine what objects a user-defined function depends upon?
Can you explain the disadvantages/limitation of the cursor?
What are the results of running this script?
How to list all field names in the result set using mssql_field_name()?
What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?
How to execute multiple stored procedures at one time in sql server?
Why do you want to join software field as you have done your BE in Electronics?
Why should we go for stored procedures? Why not direct queries?
What is wide table?
Define right outer join?
Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?
What are the different types of locks in the database?
Which rendering formats are affected by the pagesize properties?
What is sql server agent and what are the two modes of authentication in sql server?
