declare @i int,@sql varchar(250)
set @i=100 -- m+n
set @sql='select top ' + cast(@i as varchar)
+ ' * from a where id not in (select top '
+ cast(@i-1 as varchar) + ' id from a order by id desc) order by id desc'
exec(@sql)
set @i=100 -- m+n
set @sql='select top ' + cast(@i as varchar)
+ ' * from a where id not in (select top '
+ cast(@i-1 as varchar) + ' id from a order by id desc) order by id desc'
exec(@sql)
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货