max-salary.md 483 B

% This is generated by ESQL's AbstractFunctionTestCase. Do not edit it. See ../README.md for how to regenerate it.

FROM employees
| KEEP emp_no, languages, salary
| INLINE STATS max_salary = MAX(salary) BY languages
emp_no:integer salary:integer max_salary:integer languages:integer
10001 57305 73578 2
10002 56371 66817 5
10003 61805 74572 4
10004 36174 66817 5
10005 63528 73717 1