Whatz the main diff between Subquery and a Join
- 14 Answers
- 29096 Views
- Oracle, Zeta Interactive, I also Faced
- E-Mail Answers
Answer Posted / affan
the main diff is
the subquery gives the result from one table only,but whose condition may depend on another table i.e the inner query.
whereas join gives the result from both the tables if condition is satisfied
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
How to return top 5 rows in oracle?
How would you best determine why your MVIEW couldnt FAST REFRESH?
Is java required for oracle client?
If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
How to retrieve data from an explicit cursor?
How to change user password in oracle?
What is varray?
Explain compound trigger in oracle?
What is a lookup table in oracle?
How to insert a record into a table?
What are the differences between blob and clob in oracle?
What privilege is needed for a user to connect to oracle server?
What is an oracle and why it is used?
How to export data with a field delimiter?
Which are the five query types available in oracle?
