Re: MAX() and GROUP BY Problems...

[Chris Stubben]

Hi,

You can sort the results of a group by clause using the aggregate function, a column alias, or a column position (I think only the first is ANSI standard).


SELECT MAX(Date), MAX(Time), UserName FROM radius_accounting GROUP BY UserName ORDER BY MAX(Date) desc;

or

SELECT MAX(Date) as max_date, MAX(Time), UserName FROM radius_accounting GROUP BY UserName ORDER BY max_date desc;

or

SELECT MAX(Date), MAX(Time), UserName FROM radius_accounting GROUP BY UserName ORDER BY 1 desc;


Chris