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
- 11947 Views
- Cognizant, I also Faced
- E-Mail Answers
Answer Posted / manda
It gives a cartesian product or a cross product.
| Is This Answer Correct ? | 11 Yes | 1 No |
Post New Answer View All Answers
What is sql and explain its components?
when MSQL8.0 is in market
Can we have two clustered index on a table?
What is the difference between cross join and natural join?
What are the types of queries in sql?
how to rename an existing column in a table? : Sql dba
what are string data types? : Sql dba
What is difference between group by and partition by?
What is clustered index sql?
Explain the uses of control file.
How do I get sql certification?
Is sql the best database?
What is information schema in sql?
Is microsoft sql free?
what is the difference between truncate and drop statements? : Sql dba
