select top 1 * from Tb_Info where Infoid not in ( select top 15 Infoid from Tb_Info order by Infoid desc ) order by Infoid desc 我的 top 1 是 当前的页数 top 15 是每页显示的数目 但是 我想在这个语句 查的是Tb_Info 表 里面 catid =21 的数据。 我该怎么加呢。
调试欢乐多
我这样修改了之后。点击下一页的时候 还是原来的数据。不变化了。 string strsql = "select top "
+ NUMCount + " * from Tb_Info where catid ="
+ Catid + " and Infoid not in ( select top "
+ number + " Infoid from Tb_Info order by Infoid desc ) order by Infoid desc";
+ NUMCount + " * from Tb_Info where catid =''"
+ Catid + "'' and Infoid not in ( select top "
+ number + " Infoid from Tb_Info order by Infoid desc ) order by Infoid desc";
FROM table1
WHERE id >
(
SELECT ISNULL(MAX(id),0)
FROM
(
SELECT TOP 页大小*(页数-1) id FROM table1 ORDER BY id
) A
)
ORDER BY id