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 / dharmendra singh
Concept of cross join
the result will be 10 bcos 5*2 = 10
Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
What are different types of queries in sql?
What is break?
Explain what is dbms?
How can we find duplicate records in a table?
What is difference between primary and secondary key?
How does one use sql*loader to load images, sound clips and documents? : aql loader
What are reports usually used for?
Why we use stored procedure instead of query?
What are the benefits of pl sql?
What is rank dense_rank and partition in sql?
What are the disadvantages of not performing database normalization?
Does execute immediate commit?
What are the advantages of pl sql over sql?
What is sql not null constraint?
Can we use loop in sql?