I have the following query...
SELECT CreateDate, count( * )
GROUP BY CreateDate
It isn't exactly what I want. Records are added to this table in 2 main
ways. First people use the web site interface to create records. In
this case, records are only added by one or 2 people and with a
significant time between record inserts. The second way is through an
import that reads data from a text file. In the second case the date on
the records will all be close together with about 60 records added per
second. What I want to do is find all the groups where the inserts all
happened with in say 10 seconds. So my group by would be more like......
GROUP BY CreateDate +- 10 SECOND
Is there a way to do this?
"Protect your digital freedom and privacy, eliminate DRM,
learn more at http://www.defectivebydesign.org/what_is_drm"
Ham Radio Repeater Database.