I am new to Sybase. Can someone tell me how to retrieve a set of records from a select query result based on the rownum.
In Oracle I will do the same as follows to get the 5 employee ids whose salary position is between 5 and 10.
select * from (select empid, rownum num, from employee order by salary) temp
where temp.num between 5 and 10
Thanks in advance