How maney row would be print after join if A table have 100
rows and B table have 50 rows...
- 9 Answers
- 10574 Views
- Hewitt, I also Faced
- E-Mail Answers
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
Do you know what are acid properties?
What are the purpose of Normalisation?
Where cross join is used?
What stored by the msdb? : sql server database administration
Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.
What are the disadvantages of using the stored procedures?
What is Service Broker in sql server 2012?
Explain try...catch with sql server?
What is the default port for SQL Server over a firewall?
How do you drop an index?
Is it ok to shrink transaction log?
Explain a join?
How to write a query with a full outer join in ms sql server?
What are the essential components of sql server service broker?
Difference between DELETE and TRUNCATE?
