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
- 4013 Views
- Synechron, TCS, I also Faced
- E-Mail Answers
Answer Posted / swetha
40 rows but using cross join we can get no of rows
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Can you move the resources after pausing the node? : sql server database administration
What is format parameter in ssrs?
Write a SQL queries on Self Join and Inner Join.
What is the difference between grant and with grant while giving permissions to the user?
What are the different index configurations a table can have?
How do I uninstall sql server 2014?
Explain the microsoft sql server delete command? : SQL Server Architecture
How except clause is differs from not in clause?
What are the types of table?
What is the sql server agent?
How to divide query output into multiple groups with the group by clause in ms sql server?
How do you implement session management in SQL Server mode?
what's new in sql server 2016?
Which autogrowth database setting is good?
How to write an inner join with the where clause in ms sql server?
