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
- 11456 Views
- Hewitt, I also Faced
- E-Mail Answers
Answer Posted / rajesh kannan.m
actually it is natural join.if two table is there like A and B
the natural join is A*B.A=100,B=50.so ans is 100*50=5000 rows.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain how does the report manager work in ssrs?
Determine how to use the inserted and deleted pseudo tables?
What are the results of running this script?
If a table does not have a unique index, can a cursor be opened on it?
What samples and sample databases are provided by microsoft?
Mention the different types of replication in sql server.
what is a live lock? : Sql server database administration
What are the new security features added in sql server 2012? : sql server security
you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration
What is merge statement?
What is data source in connection string?
Explain what are the events recorded in a transaction log?
Explain syntax for viewing trigger?
How to access the deleted record of an event?
Why do we partition data?
