Query Help

[juskor]

Okay i have a table:
Date
Hostname
Message

I would like to setup a query that would report back the top 10 hostnames that have the most messages between a certain date?

Thanks for any suggestions.

 

[PHV]

SELECT TOP 10 Hostname, Count(*) As CountOfMessages
FROM yourTable
WHERE [Date] Between [Enter start date] And [Enter end date]
GROUP BY Hostname
ORDER BY 2 DESC;

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[juskor]

Works great, exactly what I wanted.

Thanks