Re: Ordering of records in group by not possible

[Ludwig Isaac Lim <ludz_lim(at)yahoo(dot)com>]

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