22,210
社区成员
发帖
与我相关
我的任务
分享
drop table t
Create table T(date datetime, no1 char(02),no2 char(02), id int, flag char(01), other char(01))
insert into T select '20060101','A1','B1',1,'Y',''
insert into T select '20060101','C1','D1',3,'N',''
insert into T select '20060102','C1','D1',1,'Y',''
insert into T select '20070101','E1','F1',4,'N',''
insert into T select '20070101','E1','F1',3,'N',''
insert into T select '20070101','E1','F1',2,'N',''
insert into T select '20080101','P1','Q1',6,'N',''
insert into T select '20080101','P1','Q1',9,'Y',''
GO
SELECT DISTINCT M.* FROM T M
CROSS JOIN T N WHERE ABS(M.ID-N.ID)=1