您可以使用累积和：

select t.*
from (select t.*, sum(amount) over (order by amount desc, id) as running_amount
      from t
     ) t
where running_amount - amount < 75;

在mysql 8.0之前的版本中，一种方法是关联子查询：

select t.*
from (select t.*,
             (select sum(t2.amount) from t t2 where t2.amount <= t.amount) as running_amount
      from t
     ) t
where running_amount - amount < 75;

我不确定您的用例，可能可以通过以下方式完成：

SELECT 
 GROUP_CONCAT(id SEPARATOR ',') AS ids
 SUM(t.amount)
FROM (
   SELECT 
    id as id,
    'group' as group,
    amount as amount
   FROM you_table
   WHERE amount <= @amount
   ORDER BY amount DESC
   LIMIT 2) as t
GROUP BY t.group

否则需要在存储过程中使用游标：

DECLARE total;
DECLARE my_cursor CURSOR FOR SELECT id, amount FROM yourTable ORDER BY amount DESC;
DECLARE c_amount;
DECLARE c_id;
SET total = 0;
OPEN my_cursor;
counter_loop: WHILE total <= mount DO
  FETCH cursor_name INTO c_id, c_amount;
  set total = total + c_amount;
END counter_loop
CLOSE my_cursor;

代码没有被检查过，很简单。希望这能有所帮助。