go to post Roman Krejci · Jan 25, 2018 Thank you! I missed the TOP clause. It is somewhat counterintuitive, but it IS mentioned in the documentation, though. Do you think that the formselect *, %vid from (select TOP 20 * from UACCESSRIGHT order by RIGHTID) where %vid>=10(which give the same result) would be more effective? 00 Reply go to post Roman Krejci · Jan 24, 2018 I tried it. I ve got a table UACCESSRIGHT with two integer fields, one of them being RIGHTID, randomly populated.select *, %vid from (select * from UACCESSRIGHT) workedhowever, this approach is not of much use without having the possibility to order the results, so I tried:select *, %vid from (select * from UACCESSRIGHT order by RIGHTID) failed on wrong syntaxselect *, %vid from (select * from UACCESSRIGHT) order by RIGHTID gave result set, but a wrong one (%vid was NOT 100% correlated with RIGHTID, that is the order specified by %vid was different than order specified by RIGHTID value)is there any usable way to paginate the ordered sets? 00 Reply Followers:Roman has no followers yet.Following:Roman has not followed anybody yet.Global Masters badges:Roman has no Global Masters badges yet.