Interested to Buy Any Domain ? << Click Here >> for more details...
Whatz the main diff between Subquery and a Join
- 14 Answers
- 33503 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 list all indexes in your schema?
What is a trigger and what are its types in oracle?
Explain about integrity constraint?
What is the data type of dual table?
Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?
How many types of tables supported by oracle?
Differentiate between pre-select and pre-query?
What is the simplest tool to run commands on oracle servers?
Please explain oracle data types with examples?
How to delete multiple rows from a table in oracle?
How to add a new column to an existing table in oracle?
How to join two tables in a single query using oracle?
How to apply filtering criteria at group level in oracle?
What is the difference between postgresql and oracle?
What are the components of logical database structure in oracle database?
