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 반드시 해주어야 함.
댓글
댓글 쓰기