Remove duplicates with in 10 min
|
ID |
Name |
DateTime1 |
rn |
1 |
1 |
Joe |
01.03.2017 11:33:13 |
1 |
2 |
1 |
Joe |
01.03.2017 11:55:30 |
1 |
3 |
1 |
John |
15.03.2017 08:55:48 |
1 |
4 |
1 |
John |
15.03.2017 10:15:40 |
1 |
|
ID |
Name |
DateTime1 |
(No column name) |
1 |
1 |
Joe |
01.03.2017 11:33:13 |
1 |
2 |
1 |
Joe |
01.03.2017 11:33:14 |
2 |
3 |
1 |
Joe |
01.03.2017 11:33:15 |
3 |
4 |
1 |
Joe |
01.03.2017 11:55:30 |
1 |
5 |
1 |
John |
15.03.2017 08:55:48 |
1 |
6 |
1 |
John |
15.03.2017 08:55:49 |
2 |
7 |
1 |
John |
15.03.2017 10:15:40 |
1 |
|
ID |
NAME |
DATETIME1 |
1 |
1 |
Joe |
01.03.2017 11:33:13 |
2 |
1 |
Joe |
01.03.2017 11:55:30 |
3 |
1 |
John |
15.03.2017 08:55:48 |
4 |
1 |
John |
15.03.2017 10:15:40 |
|
λ
.NET NoSQL database for rapid development
|