Delete double entries from a table without primary key
| |
id |
lastprice |
updatetime |
updatems |
|---|
| 1 |
211709 |
51370 |
09:30:00 |
0 |
| 2 |
211709 |
51370 |
09:30:01 |
0 |
| 3 |
211709 |
51370 |
09:30:01 |
500 |
| 4 |
211709 |
51370 |
09:30:02 |
0 |
| 5 |
211709 |
51370 |
09:30:02 |
0 |
| 6 |
211709 |
51370 |
09:30:03 |
0 |
| 7 |
211709 |
51370 |
09:30:04 |
0 |
| 8 |
211709 |
51370 |
09:30:04 |
300 |
| 9 |
211709 |
51370 |
09:30:04 |
300 |
| |
id |
lastprice |
updatetime |
updatems |
|---|
| 1 |
211709 |
51370 |
09:30:00 |
0 |
| 2 |
211709 |
51370 |
09:30:01 |
0 |
| 3 |
211709 |
51370 |
09:30:02 |
0 |
| 4 |
211709 |
51370 |
09:30:03 |
0 |
| 5 |
211709 |
51370 |
09:30:04 |
0 |
|
λ
.NET NoSQL database for rapid development
|