想做一个分页的程序,如何获得数据库m行到n行的数据 select * from tbname where rownum <= m minusselect * from tbname where rownum <= n 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 SELECT * FROM tbname WHERE ROWNUM <= m minusSELECT * FROM tbname WHERE ROWNUM <= n用ROWNUM rownum是一个伪列,select * from (select rownum rm,a.* from table_name a) where rm<=n and rm>=m; 用这个SELECT * FROM table_name WHERE ROWNUM <= m minusSELECT * FROM table_name WHERE ROWNUM <= n select ... from (select rownum as row_num ,.... from table) where row_num between n and m; 约束的四种状态的疑问,求解释,谢谢 求一个oracle中使用正则表达式的SQL语句,在线急. 怎样获得PAKCAGE BODY中的函数名呢? 求助,存储过程中能不能将表名做为参数传进去,急!! 数据导出不成功 ^^help^^ 我是新手,请各位大虾教教我... 数据比较问题,急! 求教一个SQL的SELECT语句? 基础版没人理我,只好来这!奇怪问题,望大侠指教!!! 高难度问题,先把快照改名,再删除原来的快照后出问题 高手很容易解决的问题,asp调用存储过程,代码很短的。解决立码给100分 Oracle返回纪录集有多少种方式???
minus
SELECT * FROM tbname WHERE ROWNUM <= n
用ROWNUM
select * from (select rownum rm,a.* from table_name a) where rm<=n and rm>=m;
SELECT * FROM table_name WHERE ROWNUM <= m
minus
SELECT * FROM table_name WHERE ROWNUM <= n