回答編集履歴
1
追加
answer
CHANGED
|
@@ -4,4 +4,13 @@
|
|
|
4
4
|
select t1.* from `tbl` t1
|
|
5
5
|
join (SELECT name, min(register_num) register_num FROM `tbl` GROUP BY name HAVING COUNT(*) > 1) t2
|
|
6
6
|
on t1.name=t2.name and t1.register_num != t2.register_num;
|
|
7
|
+
```
|
|
8
|
+
|
|
9
|
+
DELETE
|
|
10
|
+
```sql
|
|
11
|
+
delete from `tbl` tt using
|
|
12
|
+
(select t1.* from `tbl` t1
|
|
13
|
+
join (SELECT name, min(register_num) register_num FROM `tbl` GROUP BY name HAVING COUNT(*) > 1) t2
|
|
14
|
+
on t1.name=t2.name and t1.register_num != t2.register_num) t3
|
|
15
|
+
where tt.id=t3.id;
|
|
7
16
|
```
|