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

How do you use a while loop in pl sql?

939

Is t sql a programming language?

1003

Is sql a dbms?

937

What is a delimiter in sas?

976

What is the maximum size of sqlite database?

1039

How do I run pl sql in sql developer?

1057

How many clustered indexes can be created on a table?

1022

What is replication id?

886

What are all the ddl commands?

1113

What are the basic techniques of indexing?

1012

What is substitution variable in pl sql?

978

How to avoid using cursors? What to use instead of cursor and in what cases to do so?

1123

Can you rollback after commit?

930

What is nvarchar max in sql?

959

How do we use distinct statement? What is its use?

975