Wrong? How to read the second record

huoyu5

Is it top1 or top2?

terrorlin

The inner layer SELECT uses order by, while the outer layer still uses 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

The landlord should consolidate the language

huoyu5

Please correct