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 = , > .