Whatz the main diff between Subquery and a Join
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 redo log?
State the various uses of dbcc command?
What is the purpose of save points in oracle database?
How to update a table row with a record?
Does facebook use oracle?
How to change system global area (sga) in oracle?
What are the various types of snapshots ?
How to get a list of all user accounts in the database?
How to write text literals in oracle?
What is the use of oracle?
Calculate difference between 2 date / times in oracle sql?
How to write an inner join with the where clause in oracle?
What is clustered table in Oracle?
What are the set operators union, union all, minus & intersect meant to do?
How to create a new table in your schema?