Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.
select * from ( select X, min(datefield) as minDt from T1 group by X having count(*) > 5 ) T1 join ( select X, max(datefield) as maxDt from T2 group by X having count(*) > 5 ) T2 on T2.X = T1.X and T2.minDt > dateadd(minute,-30,T1.maxDt)
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
12 Experts available now in Live!