On May 12, 3:44 pm, genzeryk <genze...@gmail.com> wrote:
> 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

select id, (a + b + c + d) theSum
from someTable
order by (a + b + c + d) desc