Interested to Buy Any Domain ? << Click Here >> for more details...
Whatz the main diff between Subquery and a Join
- 14 Answers
- 33491 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 are the different oracle database objects?
What is the meaning of recursive hints in oracle?
What is the sql query to concatenate column values from multiple rows in oracle?
how may join possible between (requisition with purchase order)
How to write a query with an inner join in oracle?
Explain the use of control file?
How to connect the oracle server as sysdba?
What are transaction isolation levels supported by oracle?
How do I find my oracle client driver version?
How to invoke the original export import utilities?
What are group functions in oracle?
What are the data types in oracle?
How to delete a column in an existing table in oracle?
What is redo log?
What is translate in oracle?
