Whatz the main diff between Subquery and a Join
- 14 Answers
- 31026 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
Explain about achiever in sql?
What is the meaning of recursive hints in oracle?
How to divide query output into groups in oracle?
What is oracle latest version?
How to invoke the original export import utilities?
How many types of tables supported by oracle?
definition of cluster and non-clustered index?
How would you best determine why your MVIEW couldnt FAST REFRESH?
What are transaction isolation levels supported by oracle?
How to create a new table by selecting rows from another table?
How to connect to oracle using service name instead of sid?
What is the data pump import utility?
Where are the settings stored for each instance in oracle?
6. Display the client name and order date for all orders using the traditional method.
What are a cluster and non-cluster index?
