Feature idea: min() and max() aggregation functions

[Taitava]

Just like we have sum(), would it be possible to have min() and max() aggregation functions too? min() would iterate an array and return the smallest number in it, while max() would return the biggest number.

Background: I'm generating some kind of ID numbes in my database. I generate them manually as running numbers, starting from 1. Whenever I need to create a new ID number, I'd like to quickly see what was the last ID number that was used. I could use max() to get the maximum existing ID number and increase it by one to get a number that is not yet in use.

Thank you! 🙂

[blacksmithgu]

Do I not already have those? Interesting. I've added min, max, minby and maxby for 0.4.6.

[Taitava]

Oh, nice! 😎