Hi
I have a huge SQL server 2000 table in which there is a field "KeyID",each value of KeyID corresponds to a famous personality,we have in our database over 200 KeyID which means over 200 personalities,each record has a keyID and my database has over 250000 records,I want to know the top 10 KeyID
(the top 10 personalities) that occur the most in the database

Can anyone guide me?

thanks