How to select as many rows from the database, the value of the sum of the columns of which is less than the variable?

Question

MySQL

Hello, is it possible to write a query to select only the number of rows, the sum of cell values ​​of a certain column was less than a certain value?

Answer 1

Perhaps something like this:

select T1.* from
  TABLE T1
  inner join TABLE T2 on T2.ID<=T1.ID
group by T1...
having sum(T2.TARGET_VALUE)< [значение, с которым нужно сравнить]