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 the difference between myisam static and myisam dynamic? : Sql dba

1021

What is sql query optimization?

1051

how to use case expression? : Sql dba

973

Why is %isopen always false for an implicit cursor?

1061

What is left join in postgresql?

1008

Does sqlite need a server?

1011

How do you rename a table in sql?

1057

In what condition is it good to disable a trigger?

984

Why triggers are used?

950

Explain autonomous transaction.

1119

How to assign sql query results to pl sql variables?

1013

How to fetch alternate records from a table?

1179

What is the difference between truncate and drop statements?

1120

What is the difference between inner join and natural join?

968

what is the bond code in materialized view?

2956