Difference between sub query and nested query ?

Answer Posted / mohammed al-fahed

The query inside a query is known as a subquery.
When we have another query again query inside subquery then
it is known as nested subquery, which resinde in the WHERE
clause.

Is This Answer Correct ?    3 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

State the difference between a primary key and foreign key?

517


What are the attributes of the cursor?

558


Whether any commands are used for months calculation? If so, what are they?

595


What is index-organized table in Oracle?

573


How to drop an existing view in oracle?

568






Can you have more than one content canvas view attached with a window ?

1815


How to start a new transaction in oracle?

591


Explain about achiever in sql?

584


What are the components of logical database structure in oracle database?

579


Which is better Oracle or MS SQL? Why?

5435


How to test null values?

678


How to connect ms access to oracle servers?

552


What is a view and how is it different from a table?

572


How to convert character types to numeric types?

577


What is columnar storage what is the advantage?

544