从表中获取日期差异记录

这假定inquiryid是表的PK。我还以为你想数东西 两个小时。

Select Distinct T1.CustomerId
From Table As T1
Where Exists    (
                Select 1
                From Table As T2
                Where T2.CustomerId = T1.CustomerId
                    And T2.EnquiryId <> T1.EnquiryId
                    And Abs(DateDiff(hh, T1.DateCreated, T2.DateCreated)) <= 2
               )

SELECT [CustomerId]
  FROM [Table]
 WHERE [DateCreated] >= DATEADD(hour, -2, GETDATE())
   AND [CustomerId] = xxx;