How maney row would be print after join if A table have 100
rows and B table have 50 rows...
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
explain different types of joins? : Sql server database administration
What is index, cluster index and nonclustered index?
What is sql profiler. What are the default templates with it? : sql server database administration
What stored by the tempdb ? : sql server database administration
What is a sql join?
Do you know the cursor optimization tips?
how would you improve etl (extract, transform, load) throughput?
What is the difference between varchar and nvarchar datatypes?
Can we add a cpu to sql server?
What is the difference between osql and query analyzer?
How do I view a stored procedure in sql server?
Explain about service Broker functions?
How to select all columns of all rows from a table with a select statement in ms sql server?
What is partitioned view?
What are the limitations in ssrs on sql server express edition?