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
- 11555 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 reportserver and reportservertempdb ?
Can two different columns be merged into single column? Show practically?
What is database isolation in sql server? : sql server database administration
What are security principals used in sql server 2005?
What is a not null constraint?
How to integrate the ssrs reports in application?
What does Master database contains?
What is user-defined function? Explain its types i.e. Scalar and inline table value user-defined function?
What are the types of subscriptions in SQL Server replication?
What are constraints in microsoft sql server?
What is the difference between a unique key and primary key?
How optimize sql query with multiple joins in sql server?
Give a example to search fr a string in all stored procedure in sql server.
List the advantages of using stored procedures?
What are the 7 disadvantages to a manual system?
