Interested to Buy Any Domain ? << Click Here >> for more details...
How maney row would be print after join if A table have 100
rows and B table have 50 rows...
- 9 Answers
- 11457 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
What are the advantages to use stored procedures?
how many clustered indexes can be created on a table? : Sql server database administration
List the advantages of using stored procedures?
Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?
What stored by the master?
How to see existing views in ms sql server?
How do I view views in sql server?
How do I shrink an ldf file?
you added a row to a view, but the row is not shown on the view. Explain how this can happen, and how you can remedy the situation
Explain the xml support sql server extends?
What is compression - row-level and page-level compression?
How to choose all records from the table?
What is a cube? : sql server analysis services, ssas
How to return the date part only from a sql server datetime datatype?
what are acid properties? : Sql server database administration
