select top 1 * from (select top 3 * from tablename)t1 order by id desc
上面的如果ID字段不是排序字段的情况 select top 1 * from 表名 where id not in (select top 2 id from 表名)
USE PUBS if exists(select * from sysobjects where name='Tb' and xtype='U') drop table Tb GO --生成测试用数据,为SELECT初始环境 CREATE TABLE Tb(bID varchar(10)) INSERT INTO Tb SELECT '1349' UNION ALL SELECT '1376' UNION ALL SELECT '13533' UNION ALL SELECT '13716' UNION ALL SELECT '13717' UNION ALL SELECT '13718' UNION ALL SELECT '13761' UNION ALL SELECT '1349178' UNION ALL SELECT '1376899'GO select * from Tb --此句为SQL select top 1 * from Tb where bid not in (select top 2 bid from Tb) GO --删除测试用数据 drop table Tb
select top 1 * from 表名 where id not in (select top 2 id from 表名)
if exists(select * from sysobjects where name='Tb' and xtype='U') drop table Tb
GO
--生成测试用数据,为SELECT初始环境
CREATE TABLE Tb(bID varchar(10))
INSERT INTO Tb SELECT '1349'
UNION ALL SELECT '1376'
UNION ALL SELECT '13533'
UNION ALL SELECT '13716'
UNION ALL SELECT '13717'
UNION ALL SELECT '13718'
UNION ALL SELECT '13761'
UNION ALL SELECT '1349178'
UNION ALL SELECT '1376899'GO
select * from Tb
--此句为SQL
select top 1 * from Tb where bid not in (select top 2 bid from Tb)
GO
--删除测试用数据
drop table Tb