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(*) a
> 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
Sorry I am new to SQL and any help would be greatly appreciated
Here is my table
CREATE TABLE host_list (
number mediumint(9) NOT NULL auto_increment,
date datetime NOT NULL default '-00-00 00:00:00',
hostname varchar(75) NOT NULL default '',
PRIMARY KEY (number)
) TYPE=MyISAM;
h