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
- 12106 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
List down some advantages of sql stored procedure?
Explain trigger and its types?
What is perspective, have you ever created perspective? : sql server analysis services, ssas
What is a trace frag?
Why do we partition data?
What is the cartesian product of table?
What is local temp table?
What different steps will a sql server developer take to secure sql server?
What do you mean by a Composite primary key?
what is bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration
What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks
Can we add our custom code in ssis?
Explain subquery and state its properties?
How many full-text indexes can a table have?
Explain the types of indexes.
