Top 10 group by question

bart · Post by **bart** » Tue Sep 03, 2002 7:23 pm

Lets say I have a table with many thousands of records having three fields: When counter,Category varchar, and Rank integer.

What I want to is periodically (once an hour) reduce the number of records by deleting all but the ten with the highest Rank in each Category. New records are added all the time, but I only want to keep the daily top 10.

Whats the simplest / most expedient SQL and/or Vortex that'll do this?

bart · Post by **bart** » Tue Sep 03, 2002 8:21 pm

Nevermind, it was so simple Im embarrassed asked.

jkj2001 · Post by **jkj2001** » Thu Sep 05, 2002 5:12 pm

I'm not too embarrassed to ask-- what was your solution? Inquiring minds want to know..