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

How do I count records in sql?

992

What is embedded sql with example?

1036

What is difference between function and trigger?

1044

what happens if null values are involved in expressions? : Sql dba

1039

How do I save the results of sql query in a file?

973

Difference between global and parameter variables?

1963

Can you skip header records while loading? : aql loader

1052

What is a sql select statement?

1032

What are sql indexes?

993

What is index example?

1002

Are sql connections encrypted?

1017

How to get each name only once from an employee table?

1111

what is the use of friend function? : Sql dba

1017

What are the sql versions?

939

What is the syntax to add a record to a table?

1087