Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Select TOP
Message
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Miscellaneous
Thread ID:
00058204
Message ID:
00058746
Views:
31
>>Do you think I can use another method ?
>
>regular sql stmt sorted descending by field, then select top 10 from there? don't think it would be any faster.

Fastest way I've found is to index/set order to Field, SKIP n records,
get boundvalue, then SELECT WHERE Field > boundvalue
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.
Previous
Reply
Map
View

Click here to load this message in the networking platform