Help with query....

Please see query below:

SELECT COUNT(DISTINCT target) FROM iislog where target like '%answeringservice%'

The result of the query is 71, is there a way to list the values out in the output of the query.

for example: /answeringservice/default.asp = 3200
/answeringservice/deny.asp = 3700

Thanking you all in advance.

Lystrayes

SELECT DISTINCT target FROM iislog where target like '%answeringservice%'|||No

SELECT DISTINCT target, Count(target) as 'total' FROM iislog where target like '%answeringservice%'
Group By target|||the question was "is there a way to list the values out in the output of the query"

so you're saying it's not possible, white knight?

:)

by the way, when you use GROUP BY, the DISTINCT is redundant|||Yes it's possible

The code given did not do it!
sorry If I confused the issue|||White Knight, the code work well, thanks

Lystra