That worked perfectly, thanks! On Fri, Feb 22, 2008 at 4:49 AM, C.R.Vegelin <[EMAIL PROTECTED]> wrote: > Hi Waynn, > > Try: > SET @row := 0; > SELECT @row := @row + 1 AS Rank, > > UserId, count(*) as NumActions from Actions group > by UserId order by NumActions desc limit 10; > > HTH, Cor > > > > ----- Original Message ----- > From: "Waynn Lue" <[EMAIL PROTECTED]> > To: <mysql@lists.mysql.com> > Sent: Friday, February 22, 2008 10:38 AM > Subject: SELECT ascending incremental values > > > > 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] > > > > > > >
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]