Re: select sum as

2022-06-07 Thread Thiebo
t;> Hello, >> >> I'm trying to do this SQL request (postgresql) : >> >> select SUM (montant) AS solde FROM entrees WHERE account_id = 1 and >> date_de_valeur >= '2022-02-01' and date_de_valeur < '2022-03-01' >> >> Reading the documentation on virtua

Re: select sum as

2022-06-07 Thread Jeremy Evans
On Mon, Jun 6, 2022 at 10:06 PM Thiebo wrote: > Hello, > > I'm trying to do this SQL request (postgresql) : > > select SUM (montant) AS solde FROM entrees WHERE account_id = 1 and > date_de_valeur >= '2022-02-01' and date_de_valeur < '2022-03-01' > > Reading the do

select sum as

2022-06-06 Thread Thiebo
Hello, I'm trying to do this SQL request (postgresql) : select SUM (montant) AS solde FROM entrees WHERE account_id = 1 and date_de_valeur >= '2022-02-01' and date_de_valeur < '2022-03-01' Reading the documentation on virtual rows, I do this in Sequel: DB[:entrees].select{[sum(m