6,210
社区成员
发帖
与我相关
我的任务
分享
TRANSFORM First([A 查询].data1) AS data1之第一条记录
SELECT [A 查询].cdate
FROM (SELECT A.cdate, "type "+A.type+" data 1" as TYPE , A.data1
FROM A
UNION ALL SELECT A.cdate,"type "+ A.type+" data 2", A.data2
FROM A) AS [A 查询]
GROUP BY [A 查询].cdate
PIVOT [A 查询].TYPE;
TRANSFORM First([A 查询].data1) AS data1之第一条记录
SELECT [A 查询].cdate
FROM [SELECT A.cdate, "type "+A.type+" data 1" as TYPE , A.data1
FROM A
UNION ALL SELECT A.cdate,"type "+ A.type+" data 2", A.data2
FROM A]. AS [A 查询]
GROUP BY [A 查询].cdate
PIVOT [A 查询].TYPE;
A 查询 是为了先将数据表组织成3列