查询问题 oracle中 有一张表 tableA 有5个字段 a1, a2, a3, a4, a5要求查出 按升序的所有记录中的 3-7条数据 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 SELECT * FROM (SELECT rownum rn, t.* FROM (SELECT * FROM tableA ORDER BY a1, a2, a3, a4, a5) t WHERE rownum <= 7) WHERE rn >= 3; --按照什么排序咯?例如a1select a1,a2,a3,a4,a5from (select a1,a2,a3,a4,a5,row_number() over(order by a1) rn) where rn between 3 and 7 SELECT a1,a2,a3,a4,a5 FROM ( SELECT t1.*, ROW_NUMBER() OVER(ORDER BY a1,a2,a3,a4,a5) "RN" FROM tableA t1) t2WHERE RN >=3 AND RN <=7 日期 问题 来高人解答 PLSQL Developer查询分页是如何实现的 非常急!oracle日期函数查询出来英文月份,在线等。 急救:linux下修改了Oracle的连接数导致无法启动该怎么解决? 如何做數據備份,大家來一起來討論,研究OMS NVL函数的问题 实体化视图!!!!! 如何在处罚器中得到当前操作的类型? 如何进入sql*plus? PLSQL Developer 12 连接不上oracle 如何调试存储过程和package ORA-00918: 未明确定义列
FROM (SELECT rownum rn, t.*
FROM (SELECT * FROM tableA ORDER BY a1, a2, a3, a4, a5) t
WHERE rownum <= 7)
WHERE rn >= 3;
select a1,a2,a3,a4,a5
from (select a1,a2,a3,a4,a5,row_number() over(order by a1) rn)
where rn between 3 and 7
FROM (
SELECT t1.*, ROW_NUMBER() OVER(ORDER BY a1,a2,a3,a4,a5) "RN" FROM tableA t1
) t2
WHERE RN >=3 AND RN <=7