How maney row would be print after join if A table have 100
rows and B table have 50 rows...
Answer Posted / gopi muluka
My answer above assumes there are no common columns between
two table, in that case answer would be 5000 rows.
Otherwise Interviewer never mention about number of rows in
each table, If he is only interested in knowing what is the
default Join?
Is This Answer Correct ? | 1 Yes | 4 No |
Post New Answer View All Answers
How to drop an existing user defined function in ms sql server?
What is a transaction and why is it important?
Write down the syntax and an example for create, rename and delete index?
How to see the event list of an existing trigger using sys.trigger_events?
Explain “@@rowcount” and “@@error” in sql server?
How to use wildcard characters in like operations in ms sql server?
How use inner join in sql server?
How do you troubleshoot errors in a SQL Server Agent Job?
What is the difference function and stored procedure?
What is 1nf normalization form?
What are different types of database indexes?
What are clustered and non-clustered index?
What is the full meaning of dml?
Can we insert data if clustered index is disabled?
Explain the properties of subqueries in sql server?