MsSQL ——模拟limit

select top 1 name from nchladata..sysobjects where xtype='U' and id not in(select top 55 id from nchladata..sysobjects where xtype='U')
select top 1 name from test where name in (select top 1 name from test order by name desc) order by name asc
原文地址:https://www.cnblogs.com/picaso/p/2842045.html