>  2009/12/16 (水) 21:31:39        [qwerty]
> > select hoge, aaa, bbb, ccc from
> > (select *, aaa + bbb + ccc as sum_abc from tablename)
> > order by sum_abc
> > とか
> ごめん(;´Д`)書き忘れてましたが
> aaa,bbb,ccc,ddd,eee....とどんどん続いていくのです
> 構造として良くないのはよく分かってるけど、仕方なく(;´Д`)

select hoge, aaa, bbb, ccc, ddd, eee, ... from
(select *, aaa + bbb + ccc + ddd + eee + ... as sum_abc from tablename)
order by sum_abc

参考:2009/12/16(水)21時30分54秒