--方案三,这是一个很快的
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