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
- 4910 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
how to determine the service pack currently installed on sql server? : Sql server database administration
what is an index? : Sql server database administration
What is query optimization process?
What is SQL Azure?
What are the aggregate and scalar functions?
Find nth lowest salary or get nth lowest salary?
How to set database to be single_user in ms sql server?
What is a trigger? Why we need it?
Explain the purpose of indexes?
How to perform key word search in tables?
What are various limitations of the views?
What is a data collection table?
What are the difficulties faced in cube development? : sql server analysis services, ssas
I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that
What are policy management terms?
