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
- 12104 Views
- Hewitt, I also Faced
- E-Mail Answers
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
What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?
What is the difference between clustered and a non-clustered index?
How to delete duplicate records based on single column from a table?
Explain the third normal form(3nf)?
What are subqueries in sql server?
Write SQL queries on Self Join and Inner Join.
What is the sql server agent?
Difference between Logical Page and Physical Page in SSRS.
what authentication modes does sql server support? : Sql server database administration
What is difference between equi join and inner join?
What is nolock hint in sql server 2008
Do you know the isolation level that sql server support?
Why would you call update statistics?
What is an etl file?
How many types of functions are there in sql server?
