回答編集履歴
2
typo
answer
CHANGED
|
@@ -22,7 +22,7 @@
|
|
|
22
22
|
max(value_number) as value_number,
|
|
23
23
|
register
|
|
24
24
|
from hoge
|
|
25
|
-
group by
|
|
25
|
+
group by group_id, register
|
|
26
26
|
)
|
|
27
27
|
,
|
|
28
28
|
bb as (
|
1
typo
answer
CHANGED
|
@@ -1,5 +1,10 @@
|
|
|
1
1
|
```sql
|
|
2
|
-
create table hoge (
|
|
2
|
+
create table hoge (
|
|
3
|
+
id int,
|
|
4
|
+
group_id int,
|
|
5
|
+
value_number int,
|
|
6
|
+
register text
|
|
7
|
+
);
|
|
3
8
|
|
|
4
9
|
insert into hoge values
|
|
5
10
|
(1, 1, 11, '2025-08-01'),
|