Run Code  | API  | Code Wall  | Misc  | Feedback  | Login  | Theme  | Privacy  | Patreon 

Remove duplicates with in 10 min

Language: Layout:
View schema
Execution time: 0,02 sec, rows selected: 15, rows affected: 7, absolute service time: 0,16 sec 
edit mode |  history  | discussion
   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