回答編集履歴
2
update
test
CHANGED
|
@@ -17,10 +17,10 @@
|
|
|
17
17
|
**Query #1**
|
|
18
18
|
|
|
19
19
|
```sql
|
|
20
|
-
SELECT
|
|
20
|
+
SELECT no, STRING_AGG(name, '、') AS name
|
|
21
|
-
FROM
|
|
21
|
+
FROM users
|
|
22
|
-
GROUP BY
|
|
22
|
+
GROUP BY no
|
|
23
|
-
ORDER BY
|
|
23
|
+
ORDER BY no;
|
|
24
24
|
```
|
|
25
25
|
|
|
26
26
|
| no | name |
|
|
@@ -31,4 +31,4 @@
|
|
|
31
31
|
|
|
32
32
|
---
|
|
33
33
|
|
|
34
|
-
[View on DB Fiddle](https://www.db-fiddle.com/f/su6dJ3tHJCC9u2CpLcS9wE/
|
|
34
|
+
[View on DB Fiddle](https://www.db-fiddle.com/f/su6dJ3tHJCC9u2CpLcS9wE/3)
|
1
postgresql に変更
test
CHANGED
|
@@ -1,7 +1,7 @@
|
|
|
1
|
-
**Schema (
|
|
1
|
+
**Schema (PostgreSQL v15)**
|
|
2
2
|
|
|
3
3
|
```sql
|
|
4
|
-
CREATE TABLE users (no INT, name VARCHAR(64))
|
|
4
|
+
CREATE TABLE users (no INT, name VARCHAR(64));
|
|
5
5
|
|
|
6
6
|
INSERT INTO users VALUES
|
|
7
7
|
(1, '山田'),
|
|
@@ -10,17 +10,19 @@
|
|
|
10
10
|
(3, '福田'),
|
|
11
11
|
(3, '黒木'),
|
|
12
12
|
(3, '木下');
|
|
13
|
-
```
|
|
13
|
+
```
|
|
14
14
|
|
|
15
15
|
---
|
|
16
16
|
|
|
17
17
|
**Query #1**
|
|
18
18
|
|
|
19
19
|
```sql
|
|
20
|
-
SELECT no, G
|
|
20
|
+
SELECT "no", STRING_AGG("name", '、') AS "name"
|
|
21
|
-
FROM users
|
|
21
|
+
FROM "users"
|
|
22
|
-
GROUP BY no
|
|
22
|
+
GROUP BY "no"
|
|
23
|
+
ORDER BY "no";
|
|
23
24
|
```
|
|
25
|
+
|
|
24
26
|
| no | name |
|
|
25
27
|
| --- | -------- |
|
|
26
28
|
| 1 | 山田 |
|
|
@@ -29,4 +31,4 @@
|
|
|
29
31
|
|
|
30
32
|
---
|
|
31
33
|
|
|
32
|
-
[View on DB Fiddle](https://www.db-fiddle.com/f/su6dJ3tHJCC9u2CpLcS9wE/
|
|
34
|
+
[View on DB Fiddle](https://www.db-fiddle.com/f/su6dJ3tHJCC9u2CpLcS9wE/2)
|