count() query

i'm trying get list of IP address from my database where its distinct count is greater than 5

i got an error when i insert this query

select distinct src_ip, count(src_ip) from source
where count(src_ip) > 5
group by src_ip;

plez help

select src_ip, count(src_ip) from source
group by src_ip
having count(src_ip) > 5

thanks

i just wanna ask another question, after querying

select distinct src_ip, count(src_ip) from source
group by src_ip
having count(src_ip) > 5;

i got this result
e.g
src_ip count(src_ip)
10.3.12.4 45566
120.2.242.2 22
65.345.0.8 456
54.32.4.5 7
192.168.90.12 4556

can i get ascending order of count(src_ip) so that the result will look like this

src_ip count(src_ip)
10.3.12.4 45566
192.168.90.12 4556
65.345.0.8 456
120.2.242.2 22
54.32.4.5 7

thanx in advanced

first of all, no need using "distinct" since you do "group by" anyway.

Yes, you may have it like

select src_ip, count(src_ip) as c
from source
group by src_ip
having c > 5
order by c desc

(i think you meant not ASCENDING, but DESCENDING)