TSQL how to get IDs that visit X amount of location within X amount of time?
T-Sql question, i been trying to find the best solution for this one.
Say we have this theoritical table
-----------------------------------
ID | DATETIME | Location
11 | 1/27 3:30pm | a
11 | 1/27 3:31pm | b
11 | 1/27 3:32pm | c
22 | 2/14 1:10pm | g
22 | 2/14 1:12pm | i
22 | 2/15 5:48pm | w
55 | 3/18 8:48pm | d
55 | 3/18 9:48pm | e
---------------------------
I want to create a query that return IDs that been to 2 or more different location in 5 minutes. In this case if you look at the table, ID: 11 and 22 visits 2 or more different location within 5 minutes.How do I develop a query that returns the IDs that been to X amount of location within X amount of time?