查找数据表中某个字段相加的和刚好大于或等于给定值时所包含的记录

SELECT
    * 
FROM
    table t
WHERE
    ( SELECT SUM( can_num) can_num FROM table t1 WHERE t1.id <= t.id ) <= 100

@pyTzy 不好意思，我前面表述没完整，拿你的过去 如果是 ID主键为条件是对的，谢谢，现在如果我是按end_time为基准的话，该怎么实现呢，拜谢！上面问题我已经更新，麻烦帮忙看下

查找 can_num 字段垒加 大于等于 100 的所有记录，后面数据加起来也是大于等于100啊，应该是刚好临界，超过100就不查询才对吧

SET @one_id = 0;
SET @two_id = 0;
SET @three_id = 0;
SET @max_id = 0;

SELECT
    *,
    ( @max_id := max( one_id ) + 1 ) AS max_id 
FROM
    ( SELECT ( @one_id := @one_id + 1 ) AS one_id, t.* FROM test t ORDER BY t.time ASC ) t 
WHERE
    (
    SELECT
        SUM( t1.num ) AS num 
    FROM
        ( SELECT ( @two_id := @two_id + 1 ) AS two_id, t.* FROM test t ORDER BY t.time ASC ) t1 
    WHERE
        t1.two_id <= t.one_id 
    ) <= 100 
GROUP BY
    one_id UNION ALL
    (
    SELECT
        *,
        id + 1 AS max_id 
    FROM
        ( SELECT ( @three_id := @three_id + 1 ) AS one_id, t.* FROM test t ORDER BY t.time ASC ) t 
    WHERE
    one_id = @max_id 
    )