Skip to main content

Scalar & Single-Row Subqueries

Learn Scalar & Single-Row Subqueries (Subqueries, MySQL) with worked examples, diagrams and interview questions. Free on JavaSchoolLab.

Introduction A scalar subquery returns exactly one value (one row, one column) and can be used wherever a single value is allowed: in WHERE , SELECT or HAVING . A single-row subquery returns one row and is compared with operators like = , > .

More lessons in Subqueries