I need help!

Hello All, I need help please. How do i filter the summation of a column given a certain condition. For example i want to select everything from a table until the summation of numbers on a specific column is equal to or grater than 2000. find attached a sample screen grab. Then intended column in there is the amount column.

Thanking you in advance.

I've tried the below code to no avail:

while sum(mytable.amount) >= 2000 SELECT * FROM mytablel END while ;

while sum(mytable.amount) <= 2000 Do SELECT * FROM mytable END while;

I've tried the below code to no avail:

while sum(mytable.amount) >= 2000 Do SELECT * FROM mytablel END while ;

Your solution does not like SQL?

However i think you can try with:

SELECT * FROM mytablel WHERE amount > 2000