摘要:
今天在站上发现一错误,这样说吧:有一列表,我在第2页看到数据A,然后在第5页也看到数据A了!我的分页语句是这样的:select top 15 id from table1 where leibieid=1 and ish=1 and id not in(select top 90 id from table1 where leibieid=1 and ish=1 order by Gsrz desc,time desc)order by Gsrz desc,time desc将这句SQL分解成单纯的查询:select id from table1 where leibieid=1 and is 阅读全文