快速选取数据库第N条到第M条记录的方法？
1、SELECTTOP20*FROMmytableWHEREidNOTIN(SELECTTOP20idFROMmytable)2、SELECT*FROM(SELECTTO...
1、SELECT TOP 20 * FROM mytable WHERE id NOT IN(SELECT TOP 20 id FROM mytable)2、SELECT * FROM
(
SELECT TOP 20 * FROM
(SELECT TOP 120 * FROM mytable ORDER BY id) temptable1
ORDER BY id DESC
) temptable2 ORDER BY id至少要比上面的两个语句快 展开
(
SELECT TOP 20 * FROM
(SELECT TOP 120 * FROM mytable ORDER BY id) temptable1
ORDER BY id DESC
) temptable2 ORDER BY id至少要比上面的两个语句快 展开
推荐律师服务：
若未解决您的问题，请您详细描述您的问题，通过百度律临进行免费专业咨询
