|
27.02.2020, 21:57
#39931996
Ссылка:
Ссылка на сообщение:
Ссылка с названием темы:
Ссылка на профиль пользователя:
|
|
|
Участник
Откуда: На Камчатке красиво?
Сообщения: 746
Рейтинг:
0
/ 0
|
|
|
|
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
with t0 as
(
select 1 as id, 'key1' as k, 'val1' as v union all
select 1 as id, 'key2' as k, 'val2' as v union all
select 1 as id, 'key3' as k, 'val3' as v union all
select 1 as id, 'key4' as k, 'val4' as v union all
select 2 as id, 'key1' as k, 'val1' as v union all
select 2 as id, 'key2' as k, 'val2' as v
)
select *
from
t0
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
[
{
"id": 1,
"r": [
{
"k": "k1",
"v": "v1"
},
{
"k": "k2",
"v": "v2"
},
{
"k": "k3",
"v": "v3"
},
{
"k": "k4",
"v": "v4"
}
]
},
{
"id": 2,
"r": [
{
"k": "k1",
"v": "v1"
},
{
"k": "k2",
"v": "v2"
}
]
},
]
|
|
|
