SQL Nested Queries
A SQL nested query is a SELECT query that is nested inside a SELECT, UPDATE, INSERT, or DELETE SQL query. Here is a simple example of SQL nested query:
The nested query above will select all models from the Product table manufactured by Dell:
You can have more than one level of nesting in one single query.