查询第xxx行数据,用什么命令?

请赐教

---------------------------------------------------------------

假设id是主键:
select *
from (select top xxx * from yourtable) aa
where not exists(select 1 from (select top xxx-1 * from yourtable) bb where aa.id=bb.id)
---------------------------------------------------------------

如果使用游标也是可以的
fetch absolute [number] from [cursor_name]
行数为绝对行数

Published At
Categories with 数据库类
Tagged with
comments powered by Disqus