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
- 11730 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
Why union all is faster than union?
What are the options which must be set to allow the usage of optimistic models?
Some queries related to SQL
If you want to send some data from access database to sql server database. What are different component of ssis will you use?
What is index in an assignment?
What is the difference between the application object and session object?
What are the differences between triggers and stored procedures?
What happens if you delete a table that is used by a view?
Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.
The external application that is executed in one of the tasks does not have a log file, but only a screen log. How can I save the data from the screen? : sql server management studio
What is the difference between a fill factor of 100 and 0?
What is subreport?
What is executereader?
Can you please explain the difference between function and stored procedure?
What is ssrs?
