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
- 4406 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 will be the value of @@fetch_status if a row that was a part of the cursor resultset has been deleted from the database after the time the stored procedure that opened the cursor was executed?
How to update a field in SQL after ALTERING a row?
Can we write trigger for view?
What are sql dirty pages?
What are ddl (data definition language) statements for tables in ms sql server?
How many primary keys are possible in a table?
How do I completely remove sql server instance?
I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?
Write a sql query to sort on different column name according to the parameters passed in the function?
What is the difference between clustered index and primary key?
What is an identity column in insert statements?
What is the importance of a recovery model?
Explain what is analysis service repository?
While migrating Microsoft SQL Server 2008 database to SQL Azure, what can be done to ensure the database connectivity does not degrade?
Name three of the features managed by the surface area configuration tool? : sql server security
