If there are multiple matching rows in the table, then
ALL returns all of them.
SELECT ALL is identical to
DISTINCT. If both
DISTINCT specified, exception will be thrown.
ALL can also be specified inside aggregate function with the same effect(noop), for instance:
SELECT sum(ALL number) FROM numbers(10);
SELECT sum(number) FROM numbers(10);