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

Are dml statements autocommit?

1095

What are secondary keys?

1034

how does a local variable is defined using t-sql? : Transact sql

1060

Why is %isopen always false for an implicit cursor?

1153

Explain alias in sql?

1094

What are the different ddl commands in sql?

1251

In what condition is it good to disable a trigger?

1073

How to pronounce postgresql?

1098

Explain exception handling in pl/sql?

1084

how would you enter characters as hex numbers? : Sql dba

1038

Why use subqueries instead of joins?

1138

Are stored procedures compiled?

980

Does access use sql?

1101

what is a trigger in mysql? Define different types of trigger. : Sql dba

1121

What are different types of keys?

1176