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
- 11743 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
Explain different types of locks in sql server.
What do you do in data exploration
Can sub report data source be different from that of the parent report?
How to use subqueries with the in operators in ms sql server?
Explain what are the different index configurations a table can have?
What is the syntax for encrypting a column in SQL Server?
what is the difference in login security modes between v6.5 and 7.0? : Sql server database administration
How to find out what is the default collation in a database?
How use inner join in sql server?
How do I schedule a sql server profiler trace?
what are user defined datatypes and when you should go for them? : Sql server database administration
How to create dbo table in sql server?
What are the advantages of using a stored procedure?
Is truncate autocommit?
When a primary key constraint is included in a table, what other constraints does this imply?
