> SELECT COUNT(*) as count, hostname FROM host_list GROUP BY hostname ORDER
BY
> count DESC
>
>
> here is my current output
> 283 host1
> 210 host2
> 200 host10
> 110 host 3
> .....
> 1 host941
>
>
> what I would like to do is list say just the hosts that have greater then
10
> in the left column
Try adding 'HAVING count > 10' to your query.
dpk
---------------------------------------------------------------------
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