At 06:44 07.09.01, you wrote:
>here is my sql query
>
>SELECT COUNT(*) as count, hostname FROM host_list GROUP BY hostname ORDER BY
>count DESC
>
>
>what I would like to do is list say just the hosts that have greater then 10
>in the left column
use the HAVING statement as in:
SELECT COUNT(*) as count, hostname FROM host_list GROUP BY hostname ORDER
BY count DESC HAVING count>10
hand
henning schroeder
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
