hello every body...i'm new to SQL.actually i'm in Information security...but need to know some basic sql commands to fetch details in a tool called ArcSight. I want to get the top 10 event counts out of around 40 windows servers.
i have a query that finds events from all the servers in descending order.but i need only 10 top event getters.

Can any one help me with this query.

thanks a lot in advance