How maney row would be print after join if A table have 100
rows and B table have 50 rows...
- 9 Answers
- 9551 Views
- Hewitt, I also Faced
- E-Mail Answers
Answer Posted / sachin
Case 1: not common rows
then Inner join A join B <> row
full outer join A join B = 100 row
full outer join B join A = 50 row
Case 2: common rows (10)
then Inner join A join B = 10
full outer join A join B = 100
full outer join B join A = 50
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
tell me the disaster recovery plan
How to perform backup for certificates in sql server? : sql server security
What do you understand by mirroring and mention the advantages of the mirroring?
How to declare and use cursor variables?
How raid can influence database performance?
What are the default system databases in sql server 2000?
What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?
what's the difference between delete table and truncate table commands? : Sql server database administration
How do you handle datasets larger than 50 gb?
Describe how to use linked server?
What is dimension table? : sql server analysis services, ssas
Where is localdb stored?
how you can deploy an ssrs report?
Can we linked SharePoint to a SQL database?
How to convert a unicode strings to non-unicode strings?
