改成oracle分页语句.....怎么改求解。。。。
String sql = "select top 20 * from TBL_TOPIC where boardId=" + boardId + " and topicId not in(select top "+ rowBegin + " topicId from TBL_TOPIC where boardId=" + boardId + " order by publishTime desc )order by publishTime desc";
[解决办法]
select m.* from (select x.*,rownum r from (select z.* from zzg z where z.score<60 order by score) x) m where m.r>2 and m.r<4
类似这样试试
[解决办法]
select * from (
select id , pid , rootid ,title ,con ,pdate ,isleaf, rownum r ,virtualDatefrom
(select * from article where pid = 0 order by pdate desc)
)where r >= 4 and r <= 8；类似这样的
article表如下：
create table article
(
id number primary key，//id号
pid number,//父节点
rootid number,//根节点
title varchar2(256),//标题
con varchar2(1000),//内容
pdate date,//时间
isleaf number --1代表非叶子，0代表叶子
virtualDate date default Sysdate--用来flat中的排序，当有人回复主题帖时其值会改变，只有root节点才会有实在的virtualDate
)
[解决办法]
select nid,ntitle,nauthor from (
select nid,ntitle,nauthor,row_number() over ( order by nid desc ) rn from news order by nid desc
)
where rn between 41 and 50;
nid和ntitle是列名， row_number()是虚拟列
[解决办法]
select * from (select rownum,name from table where rownum <=endIndex ) where rownum > startIndex
