回答編集履歴
1
sample
answer
CHANGED
|
@@ -18,4 +18,26 @@
|
|
|
18
18
|
|C|75|
|
|
19
19
|
|C|34|
|
|
20
20
|
|
|
21
|
-
のようなデータの持ち方をした方がよいでしょう
|
|
21
|
+
のようなデータの持ち方をした方がよいでしょう
|
|
22
|
+
# sample
|
|
23
|
+
|
|
24
|
+
```SQL
|
|
25
|
+
create table tbl(id int primary key auto_increment,name varchar(10),score int);
|
|
26
|
+
insert into tbl(name,score) values
|
|
27
|
+
('A',20),
|
|
28
|
+
('A',35),
|
|
29
|
+
('A',50),
|
|
30
|
+
('A',86),
|
|
31
|
+
('A',77),
|
|
32
|
+
('B',20),
|
|
33
|
+
('B',35),
|
|
34
|
+
('B',50),
|
|
35
|
+
('C',34),
|
|
36
|
+
('C',55),
|
|
37
|
+
('C',12),
|
|
38
|
+
('C',45),
|
|
39
|
+
('C',75),
|
|
40
|
+
('C',34);
|
|
41
|
+
select name,group_concat(score) as scores from tbl group by name;
|
|
42
|
+
|
|
43
|
+
```
|