.......... are complete select-from-where blocks within another SQL query.
2024
.......... are complete select-from-where blocks within another SQL query.
- A.
Nested queries
- B.
SQL queries
- C.
Update queries
- D.
Select queries
Attempted by 642 students.
Show answer & explanation
Correct answer: A
Understanding Nested Queries
A nested query, also known as a subquery, is a query embedded within another SQL query. It acts as a complete select-from-where block used to provide data for the outer query's conditions.
This structure allows the database to process the inner query first, using its results to filter or validate data in the outer query. It enables complex logic within a single statement.