How maney row would be print after join if A table have 100
rows and B table have 50 rows...
- 9 Answers
- 10571 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
Do you know what is sql injection?
How do I view a procedure in sql server?
Mention the differences between local and global temporary tables.
Can group functions be mixed with non-group selection fields in ms sql server?
Why functions are used in sql server?
Explain the usage of floor function in sql server.
Explain subquery and state its properties?
Does a full backup include transaction log?
How is a full-text index updated?
after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?
Tell me about joins in database system and explain each in detail.
How you can minimize the deadlock situation?
What command would you use to create an index?
What is executereader?
What are unicode character string data types in ms sql server?
