In Oracle, usually query like this for paging.
SELECT * FROM (SELECT *, rownum rid FROM TABLEA WHERE rownum <= #pageend#)
WHERE rid > #pagestart#
However, there is no "rownum" function in Sybase DBMS.
How can I do that query exactlly same in Sybase?
I found some ways.
use "rowcount"
set rowcount 10
select * from TABLEA
use identity (make temp table)
SELECT *, ROWNUM=IDENTITY(8) INTO #TEMP FROM TABLEA
SELECT * FROM #TEMP WHERE ROWNUM < #pageend# AND ROWNUM >= #pagestart#
DROP TABLE #TEMP
these are not what I want.
rowcount is set at the session level and i don't want make temp table.