This term relates to any SELECT that returns a single value (one column, one row). It can be used as an expression in the SELECT, WHERE, or HAVING parts of an SQL query. If the scalar fullselect returns more than 1 row or 1 value, an error occurs. ...