我try 使用max(大小写),但无法将非透视数据转换为透视格式.
我们可以按以下格式透视此数据吗?
我的桌子:
Create table mytable (id integer,indicator text,value text);
Insert into mytable (id, indicator, value) values (1,'indicator 1', '10');
Insert into mytable (id, indicator, value) values (1,'indicator 2', 'yes');
Insert into mytable (id, indicator, value) values (1,'indicator 3', '123');
Insert into mytable (id, indicator, value) values (1,'state', 'ns');
Insert into mytable (id, indicator, value) values (1,'district', 'yr');
Insert into mytable (id, indicator, value) values (1,'block', 'ty');
id | indicator | value |
---|---|---|
1 | indicator 1 | 10 |
1 | indicator 2 | yes |
1 | indicator 3 | 123 |
1 | state | ns |
1 | district | yr |
1 | block | ty |
输出应如下所示:
id | state | district | block | indicator | value |
---|---|---|---|---|---|
1 | ns | yr | ty | indicator 1 | 10 |
1 | ns | yr | ty | indicator 2 | yes |
1 | ns | yr | ty | indicator 3 | 123 |