Specify order before group?

[Callum Macdonald]

Is it possible to specify order before grouping?

I want to group a list of user actions by user id with the most recent at the top. For example, the query would be:

SELECT * FROM UserActions ORDER BY Time DESC GROUP BY UserID;

That doesn't work because you have to specify GROUP BY before ORDER BY. However, the output of specifying them in the correct order is not what I want. It seems to pick the first record in the database as the GROUP instead of the most recent one.

What I'm actually trying to do is get a list of all the Users in order of the most recent UserAction, so as to be able to view the latest acitivity on my web site.

Any suggestions greatly appreciated,


chmac.