How to delete duplicate records using Sub query without using primary key

Asked Feb 14 '14 at 18:23

Active Feb 14 '14 at 19:22

Viewed 334 times

Here is an example of the data to query:

| ID |  NAME | MARKS |
|----|-------|-------|
|  0 | Fazal |    89 |
|  1 | Fazal |    89 |
|  2 | Fazal |    89 |
|  3 | Fazal |    89 |
|  4 | Fazal |    89 |
|  5 | Fazal |    89 |

edited Feb 14 '14 at 19:22

Martin Smith

438,706
87
741
845

asked Feb 14 '14 at 18:23

Fazal Rehman

which record do you want to have left over? – horace Feb 14 '14 at 18:31
possible duplicate of [How can I remove duplicate rows?](http://stackoverflow.com/questions/18932/how-can-i-remove-duplicate-rows) see the second answer using `ROW_NUMBER` – Martin Smith Feb 14 '14 at 19:20

How to delete duplicate records using Sub query without using primary key

0 Answers0