ALL Clause
If there are multiple matching rows in the table, then ALL
returns all of them. SELECT ALL
is identical to SELECT
without DISTINCT
. If both ALL
and 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);
equals to
SELECT sum(number) FROM numbers(10);
当前内容版权归 ClickHouse 或其关联方所有,如需对内容或内容相关联开源项目进行关注与资助,请访问 ClickHouse .