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
Mention the differences between local and global temporary tables.
How to provide default values to stored procedure parameters?
What do you understand by a view? What does the with check option clause for a view do?
What happens if you are trying to access a schema not owned by you?
What is difference between after and before?
What are the types of dml?
What is built-in/administrator?
What are the advantages of policy management?
What are subqueries in sql server? Explain its properties.
Where are sql server user names and passwords stored in sql server?
How does Report Builder support Analysis Services cubes?
What according to you is the difference between mysql and sql server performance?
What is the use of custom fields in report?
How to list all user defined functions in the current database?
What is scalar user-defined function?