22,302
社区成员




--测试数据
if not object_id(N'Tempdb..#brxx') is null
drop table #brxx
Go
Create table #brxx([zyh] NVARCHAR(20),[hzxm] nvarchar(22),[sfzh] BIGINT,[ryrq] DATETIME,[cyrq] DATETIME)
Insert #brxx
select '7001',N'张三',522625199201010011,N'20190325 09:58:03',N'20190420 10:02:01' union all
select '7002',N'李四',522625199305020012,N'20190401 09:58:03',N'20190420 10:58:25' union all
select '7003',N'张三',522625199201010011,N'20190515 08:14:00',N'20190525 09:10:02' union all
select '7004',N'王五',522625199502010014,N'20190402 08:20:01',N'20190420 11:01:20'
Go
--测试数据结束
SELECT *
FROM #brxx a
WHERE MONTH(cyrq) = 4
AND EXISTS ( SELECT *
FROM #brxx b
WHERE b.sfzh = a.sfzh
AND b.cyrq <> a.cyrq
AND DATEDIFF(DAY, a.cyrq, b.ryrq) < 30);