SUM
Posted: 2023-12-02 21:31
Hello
I am working on learning SQL better and how to use it with APPGINI. I have this code:
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 !!!!!
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 tried using GROUP BY, but it does not work, of course.
Une idée? merci !!!!!