Q: Sorting by the sum of columns?
Hi Folks!
I'm a newbie MySQL programmer. While doing my project I have faced
following problem:
I have five columns in my table (indexed 'id' and four with numerical
values). I would like to sum the numerical values into a kind of
virtual column and sort the table accordingly to the decreasing values
of the sum (of the virual column).
I have searched in numerous tutorials and FAQs but have not found
description of even similar situation.
Please help
Best regards,
Genz
|