A single-row subquery can be nested in the SELECT clause of the outer function.

Question

A single-row subquery can be nested in the SELECT clause of the outer function.​

Quizplus · Accepted Answer

A single-row subquery can be used in the SELECT clause of the outer query to retrieve a single value that can be used in further calculations or comparisons. This type of subquery returns only one row and one column. It can also be used with operators like =, >, <, etc. Nested subqueries can also be used to retrieve more complex data or multiple values.

A Single-Row Subquery Can Be Nested in the SELECT Clause