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
What are the differences between interval year to month and interval day to second?
How to loop through a cursor variable?
How to drop a stored function?
What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar
Explain about functional dependency and its relation with table design?
What is the maximum limit on the number of columns in a table?
Explain the features of oracle?
How to specify default values in insert statement using oracle?
What exactly do quotation marks around the table name do?
How to see free space of each tablespace?
Explain alias?
Oracle
How to select all columns of all rows from a table in oracle?
How to generate query output in html format?
How to export data with a field delimiter?