MAX_BY function


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?


Hi, We currently have the FIRST and LAST builtin aggregate functions: Would this work for your use case?