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 sequence in sql?

937

What does count (*) do in sql?

951

What is the requirement of self-join?

1025

How do I turn a list into a table?

905

what is meant by nl2br()? : Sql dba

973

Inline the values in PL/SQL, what does it mean.?

1156

what are the types of subquery? : Sql dba

1048

What are the types of optimization?

886

What is update query?

919

What is mdf ldf and ndf?

931

What operating systems are supported by oracle sql developer?

902

What is the main reason behind using an index?

964

Can we insert data into view?

847

Are pl sql variables case sensitive?

996

Which is faster joins or subqueries?

929