- Notifications
You must be signed in to change notification settings - Fork689
Mathias Rangel Wulff edited this pageJul 22, 2016 ·3 revisions
Maximal aggregator and function.
Syntax:
MAX([DISTINCT] expression)-- aggregatorMAX(expression1, expression2, ...)-- function
'null' will be treated as0 so if you have unclean data its suggested that you make your own aggregation withuser defined functions:
alasql.aggr.MOST=function(v,s,stage){if(stage==1)returnv;if(stage==2){if(v==null)returns;elsereturnMath.max(s,v);;}returns;};varres=alasql('SELECT MOST(a) FROM ?',[data])
© 2014-2026,Andrey Gershun &Mathias Rangel Wulff
Please help improve the documentation by opening a PR on thewiki repo