How do i?

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.

  • Haggy
  • 10 Aug
  • 1637 Views
  • 2 Answers
Your Answer

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

3
Forum   Other Related Discussions
Mysql

Didn't get the answer.
Contact people of Talent-Mysql directly by clicking here