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 / mubin ahmad

select * from a,bwill be the out put in 10 rows

Is This Answer Correct ?    11 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why do we need view in sql?

545


Which is faster union or join?

489


How delete all data from all tables in sql?

533


Inline the values in PL/SQL, what does it mean.?

625


How many times can we commit in a loop?

564






What is the mutating table and constraining table?

554


Can we insert in sql function?

537


what is a table in a database ? : Sql dba

538


what is the different between now() and current_date()? : Sql dba

522


Why cross join is used?

624


What is the purpose of a secondary key?

505


how to run 'mysql' commands from a batch file? : Sql dba

607


Why do we use procedures in sql?

546


What is the difference between microsoft sql and mysql?

507


what is the difference between primary key and unique key? : Sql dba

522