select tt.num,t.* from (select rownum,id,t1.* from t1) t,(select count(1) num from t1) tt where t.id between 21 and 40;
解决方案 »
- windows已在xx.exe中触发一个断点.其原因可能是堆被损坏
- oracle创建其它实例用户
- 求ORACLE PERSONAL EDITION下载地址!急急急!!!!!
- 请问在sql*plus worksheet里用DBMS_OUTPUT.PUT_LINE('THE');怎么看不到结果?
- 菜鸟的问题
- 求一oracle中文教程,立刻给分!!!
- コネクトについての問題
- 在oracle8.1.7下用exp卸oracle8.1.5的数据库不可行,系统提示版本不支持,我该怎么办?
- 有关ORACLE数据表的导入导出
- 很简单的问题,如何登陆企业管理器!!!
- 求UNIX下的ORACLE好书,谢谢!
- 关于dbms_job的问题
SELECT T.* FROM ( SELECT ROWNUM RID,FA,FB FROM T1 ) T
WHERE T.RID BETWEEN 1 AND 20
UNION
SELECT '总计',COUNT(*) FROM T1
SELECT T.FA, T.FB FROM ( SELECT ROWNUM RID,FA,FB FROM T1 ) T
WHERE T.RID BETWEEN 1 AND 20
UNION
SELECT '总计',COUNT(*) FROM T1
用union all比较好,这样取到最后正好是"总计"
(select T1.*,rownum rm,count(1) over (order by rownum) cont from T1)
where rm between 1 and 20 and rm<count
用union all比较好,这样取到最后正好是"总计"
对!union会消除重复