max
Aggregate function that calculates the maximum across a group of values.
Example:
SELECT max(salary) FROM employees;
SELECT department, max(salary) FROM employees GROUP BY department;
If you need non-aggregate function to choose a maximum of two values, see greatest
:
SELECT greatest(a, b) FROM table;
当前内容版权归 ClickHouse 或其关联方所有,如需对内容或内容相关联开源项目进行关注与资助,请访问 ClickHouse .