SUM

[pasbonte]

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 !!!!!