比较快的分页的sql语句

最新推荐文章于 2024-04-22 15:17:12 发布

wjw806

最新推荐文章于 2024-04-22 15:17:12 发布

阅读量633

点赞数

文章标签： sql rss

本文链接：https://blog.csdn.net/wjw806/article/details/2386265

版权

比较快的分页的sql语句

walrus 发表于 2006-6-21 21:35:00

--方案三,这是一个很快的
SELECT TOP 30 *
FROM rss
WHERE (ID <
          (SELECT MIN(id)
         FROM (SELECT TOP 1 id
                 FROM rss
                 --WHERE
                 ORDER BY id desc ) AS T))
--WHERE
ORDER BY ID desc

SELECT TOP 30 *
FROM rss
WHERE (PUBDATE <=
          (SELECT MIN(PUBDATE)
         FROM (SELECT TOP 60 pubdate
                 FROM rss
                 ORDER BY PUBDATE desc ) AS T))
ORDER BY PUBDATE desc

SELECT TOP 30 *
FROM news
WHERE (oid <=
          (SELECT MIN(oid)
         FROM (SELECT TOP 60 oid
                 FROM news where contains(标题,'超女')
                 ORDER BY oid desc ) AS T))
and contains(标题,'超女')
ORDER BY oid desc