MySQL Sum() multiple columns February 2, 2023 by Tarik SELECT student, (SUM(mark1)+SUM(mark2)+SUM(mark3)....+SUM(markn)) AS Total FROM your_table GROUP BY student