max

聚合函数，用于计算一组值中的最大值。

示例

SELECT max(salary) FROM employees;

SELECT department, max(salary) FROM employees GROUP BY department;

如果需要非聚合函数来选择两个值中的最大值，请参阅 greatest

SELECT greatest(a, b) FROM table;