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
SELECT M.* FROM T , T M WHERE ABS(M.ID-T.ID)=1 加多 t m 啥意思?
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
加多 t m 啥意思?