Link to home
Start Free TrialLog in
Avatar of nhmedia
nhmedia

asked on

Retrieve unique values in a table and rank by number of times they occur

We have a table recording hits on our web site. How could we write a query to retrieve unique IP addresses AND. The number of times each IP address occurs?

Thanks in advance
ASKER CERTIFIED SOLUTION
Avatar of Member_2_861731
Member_2_861731
Flag of Canada image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Avatar of mmr159
mmr159
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of nhmedia
nhmedia

ASKER

Thanks, both solutions  worked a treat