Re: Specify order before group?

[Jay Pipes]

When using GROUP BY, you need to group on something. Doing SELECT * means you want all the columns in the table, then grouped by UserID? That doesn't make sense.

I think what you're looking for is something like:

SELECT UserID, MAX(Time) as 'LatestAction', COUNT(*) as 'NumActions'
FROM UserAction
GROUP BY UserID
ORDER BY 'LatestAction';

Is that more like it?

Jay Pipes
Community Relations Manager, North America, MySQL Inc.

Got Cluster? http://www.mysql.com/cluster
Personal: http://jpipes.com