Whatz the main diff between Subquery and a Join
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 the difference between truncate & delete command?
How to execute a stored procedure in oracle?
What are the varoius components of physical database structure of oracle database?
What are the different types of partitions in oracle?
WHAT IS ecc 6.0
1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.
How to drop a tablespace?
11. Display the client number and name and the client number and name of the person who referred that client.
How to view all columns in an existing table?
What is the sql query to concatenate column values from multiple rows in oracle?
How can we create the complete backup of data in the oracle.
How can I create database in oracle?
What are the execution control statements?
What is a sub query? Describe its types?
What happens to the current transaction if the session is ended?