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 possible to do > this? > > Thanks! > Peter > SELECT Count(*) as Count, UserID FROM table GROUP BY UserID ORDER BY Count DESC LIMIT 5 -- Chris W KE5GIX Gift Giving Made Easy Get the gifts you want & give the gifts they want One stop wish list for any gift, from anywhere, for any occasion! http://thewishzone.com
-- 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]