如何从下往上计算累计和？

试试这个

SELECt 100+ Sum(CASE WHEN name = 'a' THEN qty ELSE 0 END)OVER(ORDER BY itemorder DESC) as modifyed_sum,       qty,       name,       itemorderFROM   YourtableORDER  BY itemorder ASC

其他方式

SELECt 100 + (SELECT Sum(CASE WHEN b.name = 'a' THEN b.qty ELSE 0 END)   FROM   yourtable  b   WHERe  a.itemorder <= b.itemorder),       qty,       name,       itemorderFROM   yourtable aORDER  BY itemorder ASC