回答編集履歴
1
カラム名訂正
test
CHANGED
|
@@ -6,11 +6,11 @@
|
|
|
6
6
|
|
|
7
7
|
set @num:=0;
|
|
8
8
|
|
|
9
|
-
select name, count(*) as count from (
|
|
9
|
+
select item_name, count(*) as count from (
|
|
10
10
|
|
|
11
|
-
select case when name=name2 or name=name3 then @num else @num:=@num+1 end as uni, name from (
|
|
11
|
+
select case when item_name=item_name2 or item_name=item_name3 then @num else @num:=@num+1 end as uni, item_name from (
|
|
12
12
|
|
|
13
|
-
select A.id, A.name, B.name as name2, C.name as name3 from tbl as A
|
|
13
|
+
select A.id, A.item_name, B.item_name as item_name2, C.item_name as item_name3 from tbl as A
|
|
14
14
|
|
|
15
15
|
left join tbl as B on B.id=A.id-1
|
|
16
16
|
|
|
@@ -24,6 +24,4 @@
|
|
|
24
24
|
|
|
25
25
|
group by uni;
|
|
26
26
|
|
|
27
|
-
|
|
28
|
-
|
|
29
27
|
```
|