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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
