Create Table Tbl(
ID INT NOT NULL,
NAME Char(6)
)
GO
Insert into Tbl Values(1,'a')
Insert Into Tbl Values(2,'b')
Insert Into Tbl Values(3,'c')
select top 2 * from Tbl where id not in(select top 5 ID from Tbl)
理解:查询前2条记录不在前5条中
Create Table Tbl(
ID INT NOT NULL,
NAME Char(6)
)
GO
Insert into Tbl Values(1,'a')
Insert Into Tbl Values(2,'b')
Insert Into Tbl Values(3,'c')
select top 2 * from Tbl where id not in(select top 5 ID from Tbl)
理解:查询前2条记录不在前5条中