PostgreSQL SyntaxLesson 41Free preview

PostgreSQL ALL

This lesson is part of PostgreSQL · All levels

Summary

The ALL operator demands a value that satisfies the comparison of all the results of the subquery at once. For example > ALL means greater than the greatest value of the subquery result, whereas = ALL only matches when all results are equal. ALL equipped ANY to create a stronger comparative condition.

Key points

ALL demands conditions satisfied for each result of the subquery.
> ALL means greater than the greatest value of the subquery.
= ALL only matches when the whole result is equal to that value.
It's perfect for finding extreme values or excluding a group of values.

Full lesson

Code examples and quizzes

Full lessons, code examples, and quizzes are available to subscribers. 5 questions.