> > 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秒