Re: Ordering of records in group by not possible

Alban Hertroys <alban@xxxxxxxxxxxxxxxxx> · Wed, 26 Apr 2006 16:30:53 +0200

Chris Kratz wrote:
Hello all,

I wanted to verify what we are seeing.

Select a, aggregate(b)
from c
group by a
order by a,b

That's a rather odd query... Values in b aren't available to order by, 
as they have been aggregated. There is no relation to the values in b 
and the values in your result set.

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

--
Alban Hertroys
alban@xxxxxxxxxxxxxxxxx

magproductions b.v.

T: ++31(0)534346874
F: ++31(0)534346876
M:
I: www.magproductions.nl
A: Postbus 416
   7500 AK Enschede

// Integrate Your World //