5*2=10 Its a cartesian product

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 / sirisha

Answer Posted / sirisha

5*2=10
Its a cartesian product

Is This Answer Correct ?

6 Yes

0 No

Please Help Members By Posting Answers For Below Questions

what is offset-fetch filter in tsql? : Transact sql

948

How do you go back in sql?

985

what is a tablespace? : Sql dba

1051

What does (*) mean in sql?

950

What is difference between db2 and sql?

999

Why we use triggers in mysql?

992

Is sql workbench free?

996

what are the differences between procedure-oriented languages and object-oriented languages? : Sql dba

1045

Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.

1012

How many commands are in sql?

1070

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

1013

what is denormalization. : Sql dba

1112

Why left join is used in sql?

979

What is the primary key?

952

Explain two easy sql optimizations.

1009