表的结构以及数据为下图 要达到的效果为下图 select [id],[name],( select sum(grade) from TB where id<=a.id) AS [grade] from TB a