Need Help with mysql query

[vicmad]

I'm running SNMP Zenoss connected to mysql database.I'm trying to select the device that fails the most from the database.

Column name called "devices" has all the device names.
Column name called "events" has all the events that are generated.

How can i write a query that will display the device that fails the most in a month? Please help.
Thanks in advance

 

[r937]

please do a SHOW CREATE TABLE for the table

please show some sample rows

r937.com | rudy.ca
Buy my new book Simply SQL from Amazon

 

[petrosky]

Hi,

This may work for you.

SELECT Devices, SUM(`Events`) AS Total FROM devices
GROUP BY Devices
ORDER BY Total DESC LIMIT 1

Regards,

Peter.

Remember- It's nice to be important,
but it's important to be nice

 

[vicmad]

Thanks Peter - It works.
One more thing is I need to display the result between the 1st of the month - 30th of the month and year should be 2010.

Thanks

 

[towerbase]

Run the query on any day this year except for 31st March, 31st May, 31st July, 31st August, 31st October and 31st December.

Andrew
Hampshire, UK