如何取得第N条记录的id的值？

[wallis]

如何取得第N条记录的id的值？
我用
select top 200 max(id) from table
取得的却是整个表的id的最大值。

[DainelLee]

select max(id) from (select top 200 from table)

[DainelLee]

select max(id) from (select top 200 * from table)


你以前的句子有问题

[icevi]

应该有个排序字段吧？
select top 1 id
from (select top 20 id from mytable order by somefield) t0
order by somefield desc

[CrazyFor]

select max(id) from (select top 200 * from table)AA

[DainelLee]

你以前句子翻译成常规的句子意思是：
从表中取出前200个最大的id

有语病哦

[愉快的登山者]

select id from tablename as A
where (select count(id) from tablename where id <= A.id ) = 200