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
- 11786 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 is sql server schema compare? How we can compare two database schemas?
Why use view instead of a table?
What is difference in performance between insert top (n) into table and using top with insert?
What are the advantages of partitioning?
How can sql server instances be hidden? : sql server security
how to avoid cursors? : Sql server database administration
Explain the first normal form(1nf)?
What objects does the fn_my_permissions function reports on? : sql server security
What are the advantages to use stored procedures?
How do I start sql server agent automatically?
What is an indexed view?
How to declare and use cursor variables?
When cursors are useful?
What is an etl file?
What is query optimization process?
