错那了？如何读取第二条记录呢

huoyu5

到底是top1还是top2?

terrorlin

内层SELECT要用order by，而外层还是用 top 1

苹果小刀

SELECT TOP 1 id,title,pic,path,content
FROM info
WHERE id not in
       (SELECT top 1 id from info
        WHERE Commend_Top=1 AND agree=1
        ORDER BY addtime desc)
AND Commend_Top=1 AND agree=1 ORDER BY addtime desc

lisongfox

sql=
"select
id,title,pic,path,content
from info t
where (select count(1) from info where id = t.id and addtime>t.addtime)=1 and Commend_Top=1 and agree=1 order by id desc"

hen_ab

楼主该巩固一下语文了

huoyu5

请你更正