Run Code  | Code Wall  | Users  | Misc  | Feedback  | About  | Login  | Theme  | Privacy 

Remove duplicates with in 10 min

Language: Editor: 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