group by/order by problem

From: Ken Quirici <kquirici_at_yahoo.com>
Date: Sun, 23 May 2010 07:45:30 -0700 (PDT)
Message-ID: <ae54609b-07e4-4472-a3c8-65c29d9b4854_at_q13g2000vbm.googlegroups.com>



Hi,

The following query:

select
player,
sum(hp) thp
from b_data
where hp = 1
group by player
order by thp
;

does not sort the results either by player or thp.

Is there some logical reason for this, or is order by only designed to sort group by's by the group by column?

Basically, how can I get it to sort by thp?

Any help MUCH appreciated.

Regards,

Ken Quirici Received on Sun May 23 2010 - 09:45:30 CDT

Original text of this message