I have this:
我有这个:
+-------+-------+-------------+
| fname | lname | DOB |
+-------+-------+-------------+
| Anna | Pass | 1999-02-09 |
| Anna | Pass | 1999-02-09 |
| Ano | Click | 1995-03-30 |
| Ano | Click | 1995-03-30 |
| Chro | Slip | 1955-09-27 |
| Chro | HONEY | 1955-09-27 |
+-------+-------+-------------++ - - - - - - - - - - - - - - + - - - - - - - - - - - - - + |帧| lname |强加于人- - - - - - - | + + - - - - - - - - - - - - - - - - - - - -安娜+ | |通过| 1999-02-09 | |安娜通过| | 1999-02-09 | |另|点击| 1995-03-30 | |另|点击| 1995-03-30 | | Chro |滑| 1955-09-27 | | Chro | 1955-09-27 | |蜂蜜+ - - - - - - - + - - - - - - - - - - - - - - - - - - - - +
Desired result:
预期的结果:
+-------+-------+-------------+
| fname | lname | DOB |
+-------+-------+-------------+
| Chro | Slip | 1955-09-27 |
| Chro | HONEY | 1955-09-27 |+ - - - - - - - - - - - - - - + - - - - - - - - - - - - - + |帧| lname |捐助| + - - - - - - - - - - - - - - + - - - - - - - - - - - - - + | Chro |滑| 1955-09-27 | | Chro | 1955-09-27 | |蜂蜜
My effort:
After removing all duplicates, I got rid of duplicates in first 4 rows. but I cannot get rid of originals
我的努力:在删除所有副本之后，我在前4行删除了副本。但我无法摆脱原作
