It is a cross join So, the output is 5*2=10

there is A table and B table in A table there 5 rows and in
b table there are 2 rows i am firing query select * from
a,b what will be the output?

Question Posted / subbu

Answer Posted / subbu

It is a cross join

So, the output is 5*2=10

Is This Answer Correct ?

13 Yes

0 No

Please Help Members By Posting Answers For Below Questions

what is clause? : Sql dba

1068

What is delimiter sql?

1015

What is a procedure in pl sql?

1221

Can we insert in sql function?

1097

Explain dml and ddl?

1008

What is Collation Sensitivity ? What are the various type ?

962

what happens if you no create privilege in a database? : Sql dba

1013

Where is pl sql used?

963

How does stored procedure reduce network traffic?

1020

Give the order of sql select?

1146

what is a constraint? Tell me about its various levels. : Sql dba

999

Explain constraints in sql?

1055

what are the different type of normalization? : Sql dba

1035

What is normalization in sql?

1027

Is time a data type in sql?

915