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
- 4944 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 we insert data into a view?
How to create a user name in a database?
Do you know what are the restrictions applicable while creating views? : SQL Server Architecture
Explain transaction isolation levels in sql server?
explain databases and sql server databases architecture? : Sql server database administration
What is the order by used for?
List all types of constraints in sql server?
How to generate create procedure script on an existing stored procedure?
How to list all user names in a database?
What is default constraint?
What do you mean by a dependent functionality in a build?
Explain different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?
How to rename an existing column with the "sp_rename" stored procedure in ms sql server?
What is normalization according to you and explain its different levels?
Do you know what are the ways available in sql server to execute sql statements?
