In my dataset i have a column called Source IP addr......which contains IP addr as its values.....
ex:
| 204.71.200.244 |
| 135.8.60.182 |
| 204.71.200.244 |
| 172.16.115.5 |
| 135.8.60.182 |
| 196.37.75.158 |
| 172.16.115.5 |
| 135.8.60.182 |
| 204.71.200.244 |
| 135.8.60.182 |
| 196.37.75.158 |
Now my goal is to calculate no of occurences of each ip addr..that is..My output should be...for ex...
193.37.75.158 2
204.71.200.244 3
Hope u got it.....
Any help.........in the logic ..........
Blocked AccountPosted Jan 27, 2009, 1:50 AM
Hi,
In my query CountIp gives the count of the individual Ip as i think that was your requirement.
Happy Coding!!
Posted Jan 21, 2009, 4:33 AM
First of all thanks for the reply......
I tried ur query man......but its just giving how mnay different ip addr are ther.........not the count value for each ip addr.....as i wanted.....
Any suggestions....
Blocked AccountPosted Jan 20, 2009, 11:31 PM
Hi,
you can do this by this query
Select
Ip,Count(IP)As CountIP from IPAddress group by IP