Concept of cross join the result will be 10 bcos 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 / dharmendra singh

Answer Posted / dharmendra singh

Concept of cross join
the result will be 10 bcos 5*2 = 10

Is This Answer Correct ?

9 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is case function?

1045

What are character functions?

1093

Can we commit inside a trigger?

1000

Mention what are the benefits of pl/sql packages?

1090

how to install mysql? : Sql dba

1119

Can ddl statements be used in pl/sql?

1152

what are all types of user defined functions? : Sql dba

1049

What is delimiter sql?

1014

Explain how can you save or place your msg in a table?

1036

What normalization means?

982

what is the difference between delete and truncate commands? : Sql dba

1074

How do you drop a trigger?

997

what is the functionality of the function htmlentities? : Sql dba

972

What are the commands used in sql?

1086

When should I use nosql database?

1018