且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

MySQL Sum()多列

更新时间:2023-02-02 22:33:19

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