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
- 12904 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
What is sql select statement?
how to drop an existing view in mysql? : Sql dba
What is a data manipulation language?
What is cte?
what is denormalization. : Sql dba
How do I run a query in pl sql developer?
What is the use of partition by in sql?
Is sql harder than python?
what are the different type of normalization? : Sql dba
What are different types of keys?
what are null values? : Sql dba
How does an execution block start and end in pl sql?
Why truncate is used in sql?
What is scalar and vector?
How to display Row Number with Records in Oracle SQL Plus?
