求一个 sqlserver的游标语句

Question

Answer 1

这和游标有什么关系？

         SELECT a1.id,
               a2.score
          FROM a a1
   CROSS APPLY (SELECT SUM(score) score
                  FROM a
                 WHERE id <= a1.id
                ) a2