I have a table....theres a surprise month protocol port utime 06 tcp 21 100002 06 tcp 21 100003 05 udp 43 100232 05 udp 21 100245
what I would like to do is select by month and by protocol but within protocol limit to the top 5 by count of port. In other words,I want the 5 most common instances of port per instance of protocol per instance of month. is this actually possible with a single query (mysql 4.0)? I have tried vairious combinations of group by and order by but however I do it, limit n, seems to do just that...limit the results to n rows... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
