I am trying to use aggregate function like max, min in jOOQ and refering their mannual but I am not understanding their examples that how they created max function and used it in their example. Can you please help me out on this. Please provide simple example if possible.
Problem I am facing
In jOOQ mannual example for aggregate function max is as follows
create.select(max(ID).add(1).as("next_id")).from(T_AUTHOR);
but when I used max in my query I am getting function max is undefined.