these would effectively settle how to get rows N through M of a result set in oracle
* :fields
1:
select * from tables where rownum <M
MINUS
select * from tables where rownum <n;
2
select * from
(select a.*,rownum r from
(select * from veh order by fatwaid order by seq) a
where rownum < =M)
where rownum <= n
3……
* :fields
1:
select * from tables where rownum <M
MINUS
select * from tables where rownum <n;
2
select * from
(select a.*,rownum r from
(select * from veh order by fatwaid order by seq) a
where rownum < =M)
where rownum <= n
3……
回复Comments
{commenttime}{commentauthor}
{CommentUrl}
{commentcontent}