sql 语法求救？

[westwood]

select max(id) in (select top 5 id from a)怎么写

简单说就怎样取得

select top 5 id from a

最后一条纪录（第5条）纪录id值
可以一句完成吗？

[shp7680]

select top 1 id From a order by id desc
不就可以了嘛

[kunbrother]

select top 1 id From (select tope 5 id from tablename) a order by id desc
试试

[BBQ]

可以
Select top 1 ID From a Where ID in (Select Top 5 ID From a Order By ID ASC) Order By ID DESC