MYSQL Order By Sum of Columns

Question

Any idea on how to order the results of a MYSQL query by the sum of two columns rather than by a single column?

Select * FROM table ORDER BY (col1+col2) desc

I know that won't work., but I hope it conveys what I want to do fairly well.

Thanks!

Answer 1

Suppose you have a table named 'Students'

Now you want to know the total marks scored by each student. So, type the following query

SELECT Name, S1, S2, SUM(S1+S2) AS TOTAL
FROM Students
GROUP BY Name, S1, S2
ORDER BY Total;

You will get the following result.