Scalar Subquery

A Subquery that returns exactly one value, so it can be compared like a number.

sql
WHERE rental_rate > (SELECT AVG(rental_rate) FROM film)

When to use

Used in PS 04 (nested queries on Sakila), typically in WHERE to compare against an aggregate such as the average rental rate.

See PS 04.

Appears in