Interested to Buy Any Domain ? << Click Here >> for more details...
Whatz the main diff between Subquery and a Join
- 14 Answers
- 33426 Views
- Oracle, Zeta Interactive, I also Faced
- E-Mail Answers
Answer Posted / a.n.v.v.siva kumar
The main difference between join and sub query is :
join is used to retrieve data from two different tables
where as in sub query we can retreive data from one table
using the result of the where condition on another table.
| Is This Answer Correct ? | 8 Yes | 8 No |
Post New Answer View All Answers
What is a synonym? What are its various types?
What is a static data dictionary in oracle?
How to write date and time interval literals in oracle?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
What is open database communication (odbc) in oracle?
How to empty your oracle recycle bin?
What privilege is needed for a user to insert rows to tables in another schema?
How data locks are respected in oracle?
Why do you create or replace procedures rather that drop and recreate.
Will you be able to store pictures in the database?explain.
State and explain about oracle instance?
How to start a new transaction in oracle?
How to store only time; not date and time?
Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?
Is rowid unique in oracle?
