Sybase row_number() 사용

SELECT *
FROM ( SELECT Description, Quantity,
       ROW_NUMBER() OVER ( ORDER BY ID ASC ) AS RowNum
FROM Products ) AS DT
WHERE RowNum <= 3
ORDER BY RowNum;

위와 같이 사용하면됨.

예제

select rownum, * from (select row_number()  over (order by dateofbegin desc) as rownum, * from ( select * from call_log where dateofbegin like '2012-08-06%' order by dateofbegin desc) as A) as B where rownum between 20 and 40; 

<Tip>

from clause 에서 테이블이 아닌 select 문을 대상으로 할때

()로 감싸준 다음 as 키워드로 naming 반드시 해주어야 함.