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

huoyu5 · 发表于 2020-2-6 14:00:01

如何读取第二条记录，这样写不知道错那了，请教，谢谢
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 · 发表于 2020-3-25 16:30:01

top 1改成top 2

shenmue024 · 发表于 2020-3-25 18:30:02

第一个top1 改成 top2

looser_01 · 发表于 2020-3-25 23:15:01

由于外面查询中有order by addtime desc,而not in中缺少了Order by addtime desc
正确
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"

讨饭猫 · 发表于 2020-3-25 23:30:01

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"

苹果小刀 · 发表于 2020-3-25 23:45:01

内层SELECT也要order by addtime desc

cqgang · 发表于 2020-3-26 09:15:01

晕~

qwqp2006 · 发表于 2020-3-26 12:15:02

楼上正解

shenmue024 · 发表于 2020-3-26 18:15:02

内层SELECT也要order by addtime desc

==========

同意,一时疏忽,没看出来.

huoyu5 · 发表于 2020-3-28 12:30:02

到底是top1还是top2?

		自动登录	找回密码
密码			立即注册