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
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
How to use clusters?
How to achieve Paging of records in SQL SERVER?
How to loop through the result set with @@fetch_status?
How do I port a number to sql server?
Explain encryption of entire databases without the need for application changes in sql server 2008?
What is a primary index?
What is update_statistics command?
What are the default system databases in sql server 2000?
How to use linked server?
Do you know nested transaction?
what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?
How to reaname table name without using sp_Rename in sql server..?
IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do
What the different components of Replication and what is their use?
What are transactions in sql?