Wrong? How to read the second record

huoyu5

How to read the second record, so I do n’t know what is wrong, please ask, thank you
sql = "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) and Commend_Top = 1 and agree = 1 order by addtime desc"

xing_532

top 1 changed to top 2

shenmue024

The first top1 is changed to top2

looser_01

Because there is order by addtime desc in the outer query, and Order by addtime desc is missing in not in
correct
sql = "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 "

讨饭猫

sql = "select top 2 id, title, pic, path, content from info where id not in (select top 1 id from info where Commend_Top = 1 and agree = 1) and Commend_Top = 1 and agree = 1 order by addtime desc"

苹果小刀

The inner SELECT must also be ordered by addtime desc

cqgang

Halo ~

qwqp2006

Upstairs solution

shenmue024

The inner SELECT must also be ordered by addtime desc

===========

Agree, I was negligent for a while and didn't see it.

huoyu5

Is it top1 or top2?