I met one problem, how to obtain each group's sum, and to save this sum as one field in script.
The scenario is I need to monitor each group's quantity, once it exceeds one value(like 2 as below), the system will send alert.
Thank you very much!
group by group;
Retrieving data ...