Re: query question: most active user

select userid,count(text) from blah group by userid; --On August 20, 2006 7:22:59 PM +0100 Peter Van Dijck <[EMAIL PROTECTED]> wrote: I have a table with userid and text. Users write text. I want to find the top 5 users who have the most rows in this table. I can't seem to figure out the que

Re: query question: most active user

brilliant, that works! Thanks! On 8/20/06, Chris W <[EMAIL PROTECTED]> wrote: Peter Van Dijck wrote: > I have a table with userid and text. Users write text. I want to find > the top 5 users who have the most rows in this table. > > I can't seem to figure out the query.. is there a query poss

Re: query question: most active user

Peter Van Dijck wrote: I have a table with userid and text. Users write text. I want to find the top 5 users who have the most rows in this table. I can't seem to figure out the query.. is there a query possible to do this? Thanks! Peter SELECT Count(*) as Count, UserID FROM table GROUP BY

query question: most active user

I have a table with userid and text. Users write text. I want to find the top 5 users who have the most rows in this table. I can't seem to figure out the query.. is there a query possible to do this? Thanks! Peter -- find videoblogs: http://mefeedia.com my blog: http://poorbuthappy.com/ease/ m