Some databases support on-the-fly temp tables that self garbage collect.

If you're very clever, you can nest-select-insert-select and pull a top 10. But you have to be clever. Depending on the database, you'll get yelled at, or you'll get very fast top tens that nobody else will be able to understand because you're so clever....

Calvin