2004/10/31 | getting some rows in oracle
类别(数据库[原创]) | 评论(2) | 阅读(121) | 发表于 11:48
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……
0

评论Comments

日志分类
首页[148]
小新的博客[原创][70]
我的文档[原创][33]
杂项[5]
企业信息化[9]
数据库[原创][12]
文档转载[17]
配置管理[2]