group by/order by problem
Date: Sun, 23 May 2010 07:45:30 -0700 (PDT)
The following query:
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.
Ken Quirici Received on Sun May 23 2010 - 09:45:30 CDT