level 1
ping1999时代
楼主
select top(10) * from suggestPhrase sp where sp.updateTime in (
( select updateTime from
(select ROW_NUMBER() OVER (ORDER BY updateTime desc) AS pos,updateTime from suggestPhrase) as T
where T.pos > @pageSize* ( @pageIndex- 1 ) AND T.pos <=@pageSize * @pageIndex))
and sp.text like '%租赁%'
order by updateTime desc;
where T.pos > @pageSize* ( @pageIndex- 1 ) AND T.pos <=@pageSize * @pageIndex))
where 后面的分页语句怎么换成动态的？
2017年10月16日 09点10分
1
( select updateTime from
(select ROW_NUMBER() OVER (ORDER BY updateTime desc) AS pos,updateTime from suggestPhrase) as T
where T.pos > @pageSize* ( @pageIndex- 1 ) AND T.pos <=@pageSize * @pageIndex))
and sp.text like '%租赁%'
order by updateTime desc;
where T.pos > @pageSize* ( @pageIndex- 1 ) AND T.pos <=@pageSize * @pageIndex))
where 后面的分页语句怎么换成动态的？