https://www.webmaster-forums.net/crss/node/1018932 en https://www.webmaster-forums.net/web-database-development/sql-question#comment-1111975 <p>and for mySQL:</p> <p>SELECT dsub<br /> FROM MyUserTable<br /> GROUP BY dsub<br /> ORDER BY COUNT(dsub) DESC<br /> LIMIT 5</p> Tue, 30 Jul 2002 22:35:49 +0000 Mark Hensler comment 1111975 at https://www.webmaster-forums.net https://www.webmaster-forums.net/web-database-development/sql-question#comment-1111973 <p>Try this:</p> <p>SELECT TOP 5 dsub<br /> FROM MyUserTable<br /> GROUP BY dsub<br /> ORDER BY COUNT(dsub) DESC</p> <p>That will return the top 5 user ids. You'll have to modify it to work with your database tables and fields.</p> Tue, 30 Jul 2002 20:40:42 +0000 Peter J. Boettcher comment 1111973 at https://www.webmaster-forums.net