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?

Answer Posted / subbu

It is a cross join

So, the output is 5*2=10

Is This Answer Correct ?    13 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is use of term?

614


Are pl sql variables case sensitive?

590


What is break?

612


What is sqlcommand?

546


Which is better join or inner query?

511






What is difference between db2 and sql?

524


What are all the different normalization?

554


How to Execute a Package in PL/SQL.?

574


What are the parts of a sql statement?

546


How much ram can sql express use?

499


What is the use of triggers?

534


What are the different set operators available in sql?

558


What is 19 null in sql?

526


Can I learn sql in a week?

542


What's the difference between a primary key and a clustered index?

504