要求吧pid = 0 的按照 id进行分页 但是一条sql语句不能有两个where吧。。
select top 5 * from article where (id not in(select top"+sPos+"id from article (oder by id desc ) order by pdate desc) where pid = 0
???小弟郁闷中,请高手指点
select top 5 * from article where (id not in(select top"+sPos+"id from article (oder by id desc ) order by pdate desc) where pid = 0
???小弟郁闷中,请高手指点
FROM (select *,ROW_NUMBER() Over(order by id) as rowNum from article ) as myTable
where rowNum between 50 and 60;
SQLServer2005是可以这样来做的