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
After removing a table from database, what other related objects have to be dropped explicitly?
What is policy management?
How to enter binary string literals in ms sql server?
What is PROJECTION Operation?
What are the results of running this script?
Can You Use A Stored Procedure To Provide Data To An Ssrs Report?
What is cube dimension? : sql server analysis services, ssas
How to create a view on an existing table in ms sql server?
How do I start sql server 2017?
How do you rename a table in sql server?
What is reportserver and reportservertempdb ?
How do I uninstall sql server 2014?
You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?
What is encryption key?
What different steps will a sql server developer take to secure sql server?