How maney row would be print after join if A table have 100
rows and B table have 50 rows...
Answer Posted / ankit misra
the result will depend upon the type of join it carry 150 rows if its a full outer join,it will carry common rows if its a natural join.
Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
Do you know what is a with(nolock)?
What are four major operators that can be used to combine conditions on a where clause?
How to grant a permission in ms sql server using "grant execute" statements?
what is denormalization? : Sql server database administration
What are pessimistic lock and optimistic lock?
What is transaction server implicit?
What is a periodical index?
How to connect Azure federated root database and apply federation in entity framework?
You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?
How to insert new line characters into strings?
What is an indexed view?
What are diverse clauses that form a part of sql?
What is Replication?
How many levels of sp nesting is possible?
How much does sql server 2016 cost?