Scalar subquery in SELECT

Question

Accepted Answer

A scalar subquery in the SELECT list executes once per row and must return exactly one value. MAX(salary) across all employees is 90000 (Alice herself). The result row is Alice | 90000 | 90000 - her salary and the overall max happen to be the same. This pattern is useful for adding a reference value (max, average) to every row without a separate JOIN.