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

How do I save a stored procedure?

526


What is left join example?

504


List the various privileges that a user can grant to another user?

585


how to present a past time in hours, minutes and seconds? : Sql dba

566


what is a table in a database ? : Sql dba

545






What is schema in sql example?

599


What does the base_object_type column shows in the user.triggers data dictionary view?

576


Can instead of triggers be used to fire once for each statement on a view?

541


how are mysql timestamps seen to a user? : Sql dba

564


What is the difference between database trigger and stored procedure?

557


Explain ddl statements in pl/sql?

578


What is java sql driver?

550


How does stored procedure reduce network traffic?

547


What is trigger types of trigger?

553


How many sql commands are there?

675