User bio
404 bio not found
Member since Jan 24, 2018
Roman has not published any posts yet.

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)  worked

however, 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 syntax

select *, %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?

Certifications & Credly badges:
Roman has no Certifications & Credly badges yet.
Global Masters badges:
Roman has no Global Masters badges yet.
Roman has no followers yet.
Roman has not followed anybody yet.