Interested to Buy Any Domain ? << Click Here >> for more details...
Whatz the main diff between Subquery and a Join
- 14 Answers
- 32912 Views
- Oracle, Zeta Interactive, I also Faced
- E-Mail Answers
Answer Posted / suryakiran
The main usage of subqueries is to retrieve a single record
from that same table or another table.
And also we can use subqueries to retrieve multiple
records,for this we have to use multiple sub queies,instead
of this its better to use joins based on a condition.
We can perform all operations for joins by using subqueries
but it is very complicated.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is the difference between pre-select and pre-query?
What happens if you lost a data file?
How to declare a local variable?
Explain cascading triggers.
What is truncate oracle?
Which is better Oracle or MS SQL? Why?
Can sub procedure/function be called recursively?
what is the dual table in oracle?
How to delete all rows a table in oracle?
In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?
What is clustered table in Oracle?
Can we create database in oracle using command line ?
What is background process in Oracle?
How to find the duplicate rows count from employees table in oracle?
Explain about the analyze command in oracle?
