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
- 4955 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
What is raid? : SQL Server Architecture
How is foreign key related to primary key?
What is a mutating table error and how can you get around it?
What is log ldf?
What command do we use to rename a database?
What is dbcc updateusage?
How to view existing indexes on an given table using sp_help?
How to disconnect from a sql server using mssql_close()?
What is a schema in ms sql server 2005?
How many types of triggers in sql server?
What is the difference between implicit and explicit transaction?
What is a linked server in sql server?
How do I run a trace in sql server?
What is difference between table aliases and column aliases? Do they affect performance?
Difference between Logical Page and Physical Page in SSRS.
