limiting the rows to where the sum a column equals a certain value in MySQL

by

Here’s a way which should work in MySQL :

SELECT
  O.Id,
  O.Type,
  O.MyAmountCol,
  (SELECT
     sum(MyAmountCol) FROM Table1
   WHERE Id <= O.Id) 'RunningTotal'
FROM Table1 O
HAVING RunningTotal <= 7

It involves calculating a running total and selecting records while the running total is less than or equal to the given number, in this case 7.

SQL Fiddle

More Related Contents:

  1. SQL Query needed for fetch value from Two identical table but not fully identical table
  2. Error related to only_full_group_by when executing a query in MySql
  3. SQL split values to multiple rows
  4. Get records with max value for each group of grouped SQL results
  5. How to reset AUTO_INCREMENT in MySQL
  6. How to declare a variable in MySQL?
  7. How to populate a table with a range of dates?
  8. MySQL Query GROUP BY day / month / year
  9. MySQL Cannot Add Foreign Key Constraint
  10. Grouping into interval of 5 minutes within a time range
  11. SQL counting all rows instead of counting individual rows
  12. Convert timestamp to date in MySQL query
  13. Update a column value, replacing part of a string
  14. In MySQL, should I quote numbers or not?
  15. MySQL add days to a date
  16. mysql dynamic query in stored procedure
  17. MySQL combine two columns into one column
  18. Check for x consecutive days – given timestamps in database
  19. MySQL Insert Into from one Database in another
  20. MySQL: LIMIT by a percentage of the amount of records?
  21. Does the order of conditions in a WHERE clause affect MySQL performance?
  22. Difference between these two joining table approaches?
  23. MySQL Stored Procedures not working with SELECT (basic question)
  24. MySQL query, MAX() + GROUP BY
  25. ERROR 1148: The used command is not allowed with this MySQL version
  26. MySQL export into outfile : CSV escaping chars
  27. Simple Random Samples from a MySQL Sql database
  28. ALTER table – adding AUTOINCREMENT in MySQL
  29. MySQL Select minimum/maximum among two (or more) given values
  30. ORDER BY alphabet first then follow by number

Leave a Comment