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
- 11968 Views
- Cognizant, I also Faced
- E-Mail Answers
Answer Posted / subbu
It is a cross join
So, the output is 5*2=10
| Is This Answer Correct ? | 13 Yes | 0 No |
Post New Answer View All Answers
Which certification is best for sql?
What is difference between left and right outer join?
Explain the insert into statements in sql?
what is a database? : Sql dba
What operating systems are supported by oracle sql developer?
Is oracel sql developer written in java?
What is the use of sql trace?
Is not null in sql?
How does left join work in sql?
What are the different operators available in sql?
How sql query is executed?
What is sql not null constraint?
State some properties of relational databases?
Name the operator which is used in the query for pattern matching?
What is sqlite used for?
