晕哦,人家都提示的这么清楚了,最后面少了一个括号嘛
select news.*,rowid from news where rowid in (select rowid from news where rownum<=2 and ISDELETE='0' order by news_time desc) and rowid not in (select rowid from news where rownum<=0 and ISDELETE='0' order by news_time desc))
select news.*,rowid from news where rowid in (select rowid from news where rownum<=2 and ISDELETE='0' order by news_time desc) and rowid not in (select rowid from news where rownum<=0 and ISDELETE='0' order by news_time desc))
FROM news
WHERE ROWID IN (SELECT ROWID
FROM news
WHERE ROWNUM <= 2 AND isdelete = '0')
AND ROWID NOT IN (SELECT ROWID
FROM news
WHERE ROWNUM <= 0 AND isdelete = '0')