Re: Ordering of records in group by not possible

Hi:

> You could order by "column 2" if you want to order on the
> results on
> your aggregate:
>     Select a, aggregate(b)
>     from c
>     group by a
>     order by a,2
>

another alternative is :

   select a , aggregrate(b) as <alias>
   from c
   group by a
   order by a, <alias>

e.g.

   select a,sum(b) as sum_b
   from c
   group by a
   order by a, sum_b

ludwig lim

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com