Select top 1 a from s where c>0

[CoolCHEN]

Select top 1 a from s where c>0
这是取得第一条符合要求的a字段的值，如何取得第二条？

Select top 2 a from s where c>0出来的是两条纪录，我只要一条

[tztz520]

如果想第二条记录的话,就要把游标移到第二条上再取值了

• 打赏
• 举报

回复 赞

[CoolCHEN]

一条SQL语句能不能搞定？

• 打赏
• 举报

回复 赞

[apple1980]

select top 1 a from (Select top 2 a from s where c>0 order by id)aaa order by id desc

• 打赏
• 举报

回复 赞

[vbman2003]

SELECT TOP 1 a FROM s
WHERE c>0 And a NOT IN (SELECT TOP 1 a FROM s WHERE c>0)
ORDER BY a

• 打赏
• 举报

回复 赞

[RUKYO]

Select Top 1 m.a From (Select Top 2 a,d From s Where c>0 Order By d Asc) m Order By m.d Desc

• 打赏
• 举报

回复 赞

[wumylove1234]

select top 1 * from
(select top 2 * from table where zsbh not in (select top 1 zsbh from table)) a

• 打赏
• 举报

回复 赞