ALL Clause

If there are multiple matching rows in a table, then ALL returns all of them. SELECT ALL is identical to SELECT without DISTINCT. If both ALL and DISTINCT are specified, then an exception will be thrown.

ALL can be specified inside aggregate functions, although it has no practical effect on the query's result.

For example:

SELECT sum(ALL number) FROM numbers(10);

Is equivalent to:

SELECT sum(number) FROM numbers(10);