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,
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
