One way to do that:
select Originator, CountOf from (select distinct Originator, count(Originator) as CountOf from dbo.eCSRStat WHERE {fn TIMESTAMPDIFF(SQL_TSI_HOUR,LastTreatmentStamp, CURRENT_TIMESTAMP)} <= 700 group by Originator ) where CountOf > 1
=> show all Originators occurring more than once within the last 700 hours.
This is just an example and can be enhanced if required.
|