如何在SQL中获取sum等于给定的行

SELECT *
FROM sales s1
WHERE (SELECT SUM(amount) FROM sales s2 WHERE s2.id <= s1.id) = 100;

WITH cumulative_sales AS (
    SELECT id, amount, SUM(amount) OVER (ORDER BY id) AS running_total
    FROM sales
)
SELECT id, amount
FROM cumulative_sales
WHERE running_total = 100;

DECLARE @sum INT = 0;
DECLARE @id INT;
DECLARE cur CURSOR FOR SELECT id, amount FROM sales ORDER BY id;
OPEN cur;

FETCH NEXT FROM cur INTO @id, @amount;
WHILE @@FETCH_STATUS = 0
BEGIN
    SET @sum = @sum + @amount;
    IF @sum = 100
    BEGIN
        -- 找到满足条件的行，进行处理
        PRINT 'Found at ID: ' + CAST(@id AS VARCHAR);
        BREAK;
    END
    FETCH NEXT FROM cur INTO @id, @amount;
END

CLOSE cur;
DEALLOCATE cur;