How maney row would be print after join if A table have 100
rows and B table have 50 rows...
Answer Posted / brajesh kumar srivastava
its depend on join what type join you are using,If You are
using cross join then 100*50 record would printed.
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is a non equi join?
What do you understand by recursive stored procedure?
How do we synchronize On-Premise SQL server with SQL Azure?
List down some advantages of sql stored procedure?
You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?
explain databases and sql server databases architecture? : Sql server database administration
How to rebuild all indexes on a single table?
What are different types of roles provided by ssrs?
How to compare the top two records using sql?
What is the default server name for sql server?
what is database replicaion? What are the different types of replication you can set up in sql server? : Sql server database administration
Scalability, Availability, Integration with internet, etc.)?
What will happen if a column containing char type data is changed to the nchar data type?
What is the use of set nocount on/off statement?
What is a covered index?