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
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/archive/2013/01/02/2842045.html