Glossary: SQL Beyond the Basics
Scalar subquery
A subquery that returns exactly one row and one column, so it can be used anywhere a number can, such as `price > (SELECT AVG(price) …)`.
Glossary: SQL Beyond the Basics
A subquery that returns exactly one row and one column, so it can be used anywhere a number can, such as `price > (SELECT AVG(price) …)`.