Non-scalar subquery in place of a scalar value

Subquery may return more than one row.

A subquery in the column list must be scalar, meaning that it can return just one value. Even if you correctly place just one expression in your select list, you must also ensure that just one row is returned. TOP 1 can be used if there is an ORDER BY clause

Available in

SQL Prompt

SQL Code Guard