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)
转载于:https://www.cnblogs.com/zhuangke668/p/4972306.html
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)
转载于:https://www.cnblogs.com/zhuangke668/p/4972306.html