If the database contains multiple exactly matching records, how to preserve only only one record, and delete rest duplicate of all records?

Asked Aug 21 '17 at 13:16

Active Aug 21 '17 at 13:16

Viewed 15 times

Consider their id is also same. Then how to preserve only one record, and delete rest duplicate of all records?

+-------+--------+--------+-------+
| empid | name   | salary | dept  |
+-------+--------+--------+-------+
|   100 | danial |  12000 | civil |
|   101 | giri   |   7000 | comp  |
|   100 | danial |  12000 | civil |
|   101 | giri   |   7000 | comp  |
+-------+--------+--------+-------+

Here I want to delete one danial or giri and another one should not be deleted how to do this?

edited Aug 21 '17 at 13:16

Giorgos Betsos

69,699
7
57
89

asked Aug 21 '17 at 13:16

Rajath

1,916
6
22
40

1

Have you tried anything so far to solve the problem? – Giorgos Betsos Aug 21 '17 at 13:17
1

Follow the duplicate link for a list of several methods you can use. Pick the one which works best for your data/situation. – Tim Biegeleisen Aug 21 '17 at 13:18

If the database contains multiple exactly matching records, how to preserve only only one record, and delete rest duplicate of all records?

0 Answers0