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
- 12900 Views
- Cognizant, I also Faced
- E-Mail Answers
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 is a heap in sql?
how do you know if your mysql server is alive? : Sql dba
What are operators available in sql?
What is a join?
Can we use commit inside a trigger?
Mention what plvcmt and plvrb does in pl/sql?
What are analytic functions in sql?
What are the ways on commenting in a pl/sql code?
Can we use pl sql in mysql?
How do I find duplicates in two columns?
What do you mean by rowid?
How many types of keys are there in sql?
What are inner outer left and right joins in sql?
Why do we use sqlite?
What is meant by truncate in sql?
