1、未转换前
2、 行转列函数:UNPIVOT()
SELECT * FROM (select std0, std1,std2,std3,std4,std5,std6,std9 from table t)
UNPIVOT("value" FOR "name" IN(std0 as '哈哈1',std1 as '哈哈2',std2 as '哈哈3',std3 as '哈哈4',std4 as '哈哈5',std5 as '哈哈6',std6 as '哈哈7',std9 as '哈哈8'))
1、未转换前
2、 行转列函数:UNPIVOT()
SELECT * FROM (select std0, std1,std2,std3,std4,std5,std6,std9 from table t)
UNPIVOT("value" FOR "name" IN(std0 as '哈哈1',std1 as '哈哈2',std2 as '哈哈3',std3 as '哈哈4',std4 as '哈哈5',std5 as '哈哈6',std6 as '哈哈7',std9 as '哈哈8'))