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


Please Help Members By Posting Answers For Below Questions

What are user-defined functions (udfs) in sql server?

758


Can we use where clause with group by?

691


What is mssql?

747


Do you know what is difference between stored procedure and user defined function?

834


Does sql server use java?

772


What do you mean by SQL injection attack?

829


How to maintain a fill factor in existing indexes?

746


What is the default sql server instance name?

785


What is set nocount on and what is set nocount off?

691


What is a rownum?

698


Tell me the phases a transaction has to undergo?

739


Explain triggers in sql?

743


How do you check sql server is up and running?

722


How to convert a numeric expression from one data type to another?

724


What is the meaning of resultset type_scroll_insensitive?

758