Thunderstone Support Forums

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?

Nevermind, it was so simple Im embarrassed asked.

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