111,094
社区成员




select * from [dbo].[Users];
with
tab as(
select CONVERT(nvarchar(20),createtime,120) ct,COUNT(1) ctCount from [dbo].[Users]
group by CONVERT(nvarchar(20),createtime,120)
having COUNT(CONVERT(nvarchar(20),createtime,120))>1
)
select * from [dbo].[Users] where CONVERT(nvarchar(20),createtime,120) in (select ct from tab);
select * from 表 a
where (select COUNT(*) from 表 b
where b.CreateTime between DATEADD(second,-1,a.CreateTime) and DATEADD(second,1,a.CreateTime))>1