MySQL Sum()多列 [英] MySQL Sum() multiple columns

问题描述

我有一张学生记分卡表. 这是桌子，

I have a table of student scorecard. here is the table,

subject  | mark1 | mark2 | mark3 |......|markn
stud1    | 99    | 87    | 92    |      | 46
stud2    |....................................
  .
  .
studn    |....................................|

现在，我需要为每个分数总计的学生加起来.我通过使用sum(mark1+mark2+...+markn) group by stud获得了它.我想知道如何在不添加每个列名称的情况下进行求和，以防出现mark26的情况.所以谁能知道如何解决它.预先感谢.

Now, i need to sum it for each student of total marks. I got it by using sum(mark1+mark2+...+markn) group by stud. I want to know how to sum it without adding each column name,it will be huge when in case up to marks26. so could anyone know how to fix it. Thanks in advance.

推荐答案

SELECT student, (SUM(mark1)+SUM(mark2)+SUM(mark3)....+SUM(markn)) AS Total
 FROM your_table
 GROUP BY student

这篇关于MySQL Sum()多列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！