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?
- 7 Answers
- 11998 Views
- Cognizant, I also Faced
- E-Mail Answers
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 |
Post New Answer View All Answers
Which is faster count (*) or count 1?
Is pl sql a programming language?
What does sql stand for?
Is it possible to read/write files to-and-from PL/SQL?
how do you login to mysql using unix shell? : Sql dba
What is the sql*loader? : aql loader
What is sql basics?
Is sqlexception checked or unchecked?
What is procedure explain with program?
What are stored procedures used for?
What is pivot table in sql?
What is the benefit of foreign key?
What does count (*) do in sql?
what is an extent ? : Sql dba
What is varchar example?
