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
- 11951 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
Why do we use sql constraints?
Does execute immediate commit?
What is pl/sql table? Why it is used?
What is a system versioned table?
What is constant in pl sql?
What does truncate mean in sql?
what is 'mysqlcheck'? : Sql dba
How is sql used in oracle?
Explain select statements in sql?
How can you load multi line records? : aql loader
what are the differences between binary and varbinary? : Sql dba
How can you know that statistics should be updated?
What is exit statement?
explain the difference between delete , truncate and drop commands? : Sql dba
What is the difference between inner join and left join?
