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 query.. is there a query possible to do
this?
Thanks!
Peter
--
find videoblogs: http://mefeedia.com
my blog: http://poorbuthappy.com/ease/
my job: http://petervandijck.net
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
"Genius might be described as a supreme capacity for getting its possessors
into trouble of all kinds."
-- Samuel Butler
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
