MAX_BY function

Hi,

It would be great if SingleStore had the MAX_BY/MIN_BY aggregation functions, as it’s a very common function used in OLAP.

Any suggestions around the best performant workaround to achieve what MAX_BY/MIN_BY do with the current functions supported by SingleStore, in a Columnstore table?

Thanks!

Hi, We currently have the FIRST and LAST builtin aggregate functions: https://docs.singlestore.com/v7.1/reference/sql-reference/time-series-functions/first/. Would this work for your use case?