ctions 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
2, 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
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, 984
