Posted by endlesstide on 04/11/06 12:47

Ok, table has thousands of records. Each record has a unique ID and a
dynamic number that could be anything. From a efficiently standpoint
(given there will be lots of transactions against this) --- how would I
query the database and request the first 50 records, sorted by
ascending value? - and also how would I query the database for a
certain set of records by Unique ID such as 250 thru 300 --- and see
those records in ascending order -relative- to the total record set?

Thanks so much if someone can tackle this rather tricky requirement.
Best regards, Dave

[Back to original message]