SUM

The recommended method of customizing your AppGini-generated application is through hooks. But sometimes you might need to add functionality not accessible through hooks. You can discuss this here.
Post Reply
pasbonte
Veteran Member
Posts: 158
Joined: 2013-02-06 09:49

SUM

Post by pasbonte » 2023-12-02 21:31

Hello

I am working on learning SQL better and how to use it with APPGINI. I have this code:

Code: Select all

SELECT SUM(`SEC_TOTAL_SAISI`) AS `ESSAI`
FROM `GES_DEMANDE_HSE_2324` 
GROUP BY `GES_DEMANDE_HSE_2324`.`NOM`
I have a sum that corresponds to the total of all the records, but I would like the total by NAME.

I tried using GROUP BY, but it does not work, of course.

Une idée? merci !!!!!

Post Reply