It is concept of CROSS JOIN.. It will display 5 * 2 = 10 rows

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 / santosh pashte

Answer Posted / santosh pashte

It is concept of CROSS JOIN..

It will display 5 * 2 = 10 rows

Is This Answer Correct ?

41 Yes

4 No

Please Help Members By Posting Answers For Below Questions

Which certification is best for sql?

981

What are the types of triggers in sql?

1087

When can we use the where clause and the having clause?

1016

How many unique keys can a table have?

1010

What is view explain with example?

926

Is mariadb nosql?

1039

How do sql databases work?

990

What are character functions in sql?

936

Which is better trigger or stored procedure?

945

What is blind sql injection?

1067

In pl/sql, what is bulk binding, and when/how would it help performance?

989

Explain dml and ddl?

986

Explian rowid, rownum?

1007

Explain the difference between rename and alias?

1010

What is int identity in sql?

1132