My knowledge of MySQL is basic. I want to build a query to return all rows when is reached that sum a given amount value
- given value: 1.20
- field to sum: amount
- order by expirydate
table:
id name expirydate amount
1 name1 11-08-16 0.20
2 name2 10-08-16 1.50
3 name3 08-08-16 1.00
I need the result from id 3, 2 order by expiry date.