初学者必读：经典的数据库记录分页代码

方案:◆1、SELECT TOP PAGESIZE NEWSTITLEFORM NEWSINFO WHERE NEWSID NOT IN(SELECT TOP (PAGE-1)* PAGESIZE NEWSID FROM NEWSINFOWHERE Auditing=1 and NEWSBREED='企业新闻' order by NEWSID DESC)AND Auditing=1 and NEWSBREED='企业新闻' order by NEWSID DES