need help with a query

[TechnoWeenie]

This is for a domain counter I'm trying to get going.
when someone hits the web site it records the IP address, resolves the IP to a domain name if possible and number of times they have visited the site.

What happens is I get hits from the same domain but different IP's so I have many rows that have the same resolved name because they have a different IP everytime they visit our site. How do I find all of the same resolved names and add up the number of times they have visited?

the table has IP address, resolved name, aka and hits

I'm using the aka and hits to do this.
I need to find all of the names that are the same in aka and add up all of the values from hits that go with them.

 

[ShihabAhmad]

try this out:
select aka,sum(hits) from <your table name>
group by aka
order by aka