select top(@endpage-@startpage+1) * from EKE_UserComments
where Display='true' and id not in
(select top (@startpage-1) id from EKE_UserComments where Display='true' order by AddTime desc)
order by AddTime desc用pl/sql怎么写
where Display='true' and id not in
(select top (@startpage-1) id from EKE_UserComments where Display='true' order by AddTime desc)
order by AddTime desc用pl/sql怎么写
-- 是不是想把这个语句改写为Oracle的?-- 悲哀,SQL和PL/SQL是两个概念,不要搞混啦!
-- 是不是想把这个语句改写为Oracle的?就是这个意思
不过改写起来很麻烦,没sql server那么简洁.
select * from (select t.*,rownum rn from EKE_UserComments t where Display='true' order by AddTime desc)
where rn between startpage and endpage
select *
from (select t1.*, rownum as rn
from (select t.* from test t order by b) t1)
where rn between and
自己传入参呗
select * from (select t1.*,rownum rn from (select t.* from EKE_UserComments t where Display='true' order by AddTime desc) t1)
where rn between startpage and endpage
where Display='true' and id not in
(select top (@startpage-1) id from EKE_UserComments where Display='true' order by AddTime desc)
order by AddTime desc][/code]
楼主这句话语法就过不去
select * from (select t.*,row_number()over(order by AddTime desc) rn from EKE_UserComments t where Display='true' ) t1
where rn between startpage and endpage;
--mssql,oracle 通用的
select t.*
from (select a.*,row_number() over(order by AddTime desc ) rn
from EKE_UserComments a
where Display='true' ) t
where rn between startpage and endpage
--
select * from EKE_UserComments
where Display='true' and rownum< (&endpage-&startpage+1)and id not in
(select id from EKE_UserComments where Display='true' and rownum<&endpage-1 order by AddTime desc)
order by AddTime desc