Re: SELECT ascending incremental values
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: > 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]
Re: SELECT ascending incremental values
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: 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]
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]