How do i?

Question

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.

I've tried the below code to no avail:

while sum(mytable.amount) >= 2000 SELECT * FROM mytablel END while ;

Thanking you in advance.

Siddharth Dubey · Answer

Hii Haggy Tommy this statement should be like SELECT * FROM mytable WHERE SUM(column_name*Amount) IS >=2000

Aqusa Hasan Siddique · Answer

SELECT * FROM tablename WHERE SUM(col-name*amount) IS >=2000;