MYSQL Order By Sum of Columns

I think you should be able to do

SELECT *, col1+col2 as mysum ORDER BY mysum

Which is essentially the same as you already have

Why not try before concluding it doesn't work? In point of fact, it does.

Suppose you have a table named 'Students'

enter image description here

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.

enter image description here

Related