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
- 4816 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 database white box testing?
How many null values we can have in a unique key field in sql server?
How to fetch the next row from a cursor with a "fetch" statement?
What are the 7 disadvantages to a manual system?
What factors you will consider calculating the storage requirement for that view?
How to download and install microsoft sql server management studio express?
What is stored in the mssqlsystemresource database? : sql server database administration
What is exporting utility?
explain what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration
How to disable stored procedure sql server?
What is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio
Write a SQL query to make a column as unique?
Which operator do you use to return all of the rows from one query except rows are returned in a second query?
What is @@rowcount in sql?
Explain transaction server implicit?
