A scalar subquery is a nested query that returns a single value (one row, one column), usable like a number in SELECT or WHERE. It is used, for example, to compare each row to a global average. If it returns several rows, the query fails.
Example
SELECT * FROM produits
WHERE prix > (SELECT AVG(prix) FROM produits);