It's been quite a while since I did any work in FP.
I have a table with "productid" and "prodcount". They are both numeric. Prodcount contains inventory counts.
What I need is to select the ten product ids with the largest counts.
The table is not indexed on the prodcount field and I cannot change that.