Sum until certain point – MySql

by

Came across this question while searching for my own answer. I thought I’d leave my solution here since it’s another way to accomplish the same task and may be more efficient. The trick is the self join using >=

    SELECT s1.ID, s1.name, s1.money, sum(s2.money) as accumulator
    FROM student s1 
    INNER JOIN student s2 ON s1.id >= s2.id 
    GROUP BY s1.id HAVING accumulator <= 500;

More Related Contents:

  1. MYSQL sum() for distinct rows
  2. How do I get SUM function in MySQL to return ‘0’ if no values are found?
  3. MySQL sum elements of a column
  4. Surpassing MySQL’s TIME value limit of 838:59:59
  5. How do I add two count(*) results together on two different tables?
  6. Recreating a query using INNER JOIN? [duplicate]
  7. Create a Cumulative Sum Column in MySQL
  8. MySQL: Enable LOAD DATA LOCAL INFILE
  9. mysql select dynamic row values as column names, another column as value
  10. Access denied for user ‘root’@’localhost’ (using password: YES) (Mysql::Error)
  11. MySQL root access from all hosts
  12. Setting up MySQL and importing dump within Dockerfile
  13. Select last N rows from MySQL
  14. SQL – IF EXISTS UPDATE ELSE INSERT INTO
  15. Simple Random Samples from a Sql database
  16. How to select date from datetime column?
  17. node.js mysql error: ECONNREFUSED
  18. How do I use properly CASE..WHEN in MySQL
  19. Delete query not working in mysql
  20. SQL Server equivalent of substring_index function in MySQL
  21. MySQL foreign key to allow NULL?
  22. MySQL : When stored procedure parameter name is the same as table column name
  23. Does a UNIQUE constraint automatically create an INDEX on the field(s)?
  24. MySQL 5.0 indexes – Unique vs Non Unique
  25. MySQL – Select from a list of numbers those without a counterpart in the id field of a table
  26. MySql – How get value in previous row and value in next row? [duplicate]
  27. Updating table in trigger after update on the same table
  28. For homebrew mysql installs, where’s my.cnf?
  29. MySQL Select Multiple VALUES
  30. Convert SQL Server query to MySQL [duplicate]

Leave a Comment