I'm migrating from a mySQL to sybase database and looking for a replacement to the mysql offset clause.
I've already figured the "set ROWCOUNT" can limit the size of the result set, but I'm missing the ability to do an offset value. Essential in the message board app. I'm working on.
Anyone got any ideas on how I can ask Sybase for 100 rows starting at the 101st? The Sybase docs aren't being very forthcoming.
I've already figured the "set ROWCOUNT" can limit the size of the result set, but I'm missing the ability to do an offset value. Essential in the message board app. I'm working on.
Anyone got any ideas on how I can ask Sybase for 100 rows starting at the 101st? The Sybase docs aren't being very forthcoming.