Re: Specify order before group?

[Callum Macdonald]

I've managed to sort this with a subquery:

SELECT * FROM (SELECT * FROM UserActions ORDER BY Time DESC) AS Actions GROUP BY UserID ORDER BY Time DESC;

I'm not sure if it's the most graceful or efficient solution, but it does work.


chmac.