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
State the difference between a primary key and foreign key?
What are the attributes of the cursor?
Whether any commands are used for months calculation? If so, what are they?
What is index-organized table in Oracle?
How to drop an existing view in oracle?
Can you have more than one content canvas view attached with a window ?
How to start a new transaction in oracle?
Explain about achiever in sql?
What are the components of logical database structure in oracle database?
Which is better Oracle or MS SQL? Why?
How to test null values?
How to connect ms access to oracle servers?
What is a view and how is it different from a table?
How to convert character types to numeric types?
What is columnar storage what is the advantage?