sql获取第n条数据

select * 
from (select top n * from students) aa 
where not exists(select * from (select top n-1 * from students) bb where aa.id=bb.id)

posted @ 2015-11-17 17:16  递龟  阅读(2098)  评论(0编辑  收藏  举报