I am working on Sybase. Want to implement pagination for a result. I can get first few records by stating set rowcount 100 But is there any way to set start point as well. The result is ordered on basis of a text value.
I tried finding at stackoverflow as well as in Sybase documentations, but could not find the way. I tried Limit, rownum() etc. but they are not supported. Also tried putting it as inner query, but somehow it is not working.
One solution I found which was of creating temp table with identity and get the same. But to the application, I do not have create table permission.
Can someone please help me in this?
