A subquery is appropriate only if the final result contains only data from a single table.

Question

Quizplus · Accepted Answer

A subquery is a query within a query. It is used to retrieve data from one or more tables and use the result as part of the main query. A subquery can be used to filter data, perform calculations, or retrieve data from multiple tables. However, a subquery is only appropriate if the final result contains only data from a single table. This is because a subquery cannot return data from multiple tables.

A Subquery Is Appropriate Only If the Final Result Contains