--1:创建一个表来测试CREATE TABLE Test_table (seqno INT ,field1 NVARCHAR(30))--2:下面是将表Test_table分别插入5笔数据INSERT INTO Test_table (seqno,field1)VALUES('1',N'列转行1')INSERT INTO Test_table (seqno,field1)VALUE
一、Presto 语法 原始数据: 期望数据: 代码: SELECT info, valueFROM ( select '张三' as name,'18' as age,'男' as gender,'清华' as schoolunion allselect '李四' as name,'18' as age,'男' as gender,'清华' as school) as