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
- 11803 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 types of containers in ssis?
What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?
Tell me time data type, datetime2, datetimeoffset data type in sql server 2008?
Explain about sql server login?
How to select true false based on column value in sql server?
What specific conditions database should meet, before you can bulk copy data into it using bcp?
What does null mean?
How much does sql server 2016 cost?
How to change the name of a database user?
How to define output parameters in stored procedures?
how would you improve etl (extract, transform, load) throughput?
Explain the dirty pages?
What is the current pricing model of SQL Azure?
What is model database in sql server?
What is query processing?
