Need Help building a query

[vicmad]

I'm running SNMP Zenoss connected to mysql.
I'm trying to select the device that fails the most from the database.
How do I do that? Please help.

Thanks in advance

 

[SQLSister]

YOu might find more help in the mysql forum, this one is for code associated with Microsoft SQL Server. Although I suspect even there you are going to need more information as the question seems a little light on details.

"NOTHING is more important in a database than integrity." ESquared

 

[markros]

I agree - when you post a question, provide a table script, some input data and desired output. Also, since MySQL syntax is a bit different than T-SQL (used in SQL Server) you can have better luck posting your question in MySQL forum.

PluralSight Learning Library

 

[vicmad]

Thanks for the feedback.