I'm doing a top 10 list from a database based on a group by and order by, something like
select UserId, count(*) as NumActions from Actions group by UserId order by NumActions desc limit 10; Is there any way to put a separate column so I get results like Rank, UserId, NumActions 1, 123, 43 2, 9844, 40 3, 88, 34 4, 144240, 20 etc.? Waynn -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]