How maney row would be print after join if A table have 100
rows and B table have 50 rows...
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
application server is slow what may be the problem
Define union, union all, minus, intersect?
Can you change the data type of a column in a table after the table has been created? If so, which command would you use?
How is sql used in sql server?
Explain the difference between control flow and data flow?
Write a sql query to get zero records from a table having n number of records?
Do you know hot add cpu in sql server 2008?
What are views used for?
What is 2nf example?
What are the restrictions that views have to follow?
How do you test your database? : sql server database administration
Where is my database stored on the hard disk in ms sql server?
What is raid and what are different types of raid levels?
What is the difference between the 2 operating modes of database mirroring?
How connect excel to sql server?