- TRANSFORM First(mid(b.汇总,2,len(b.汇总)-1)) AS 红球3之第一条记录
- SELECT b.总期数, b.红球1, b.红球2, b.红球3, b.红球4, b.红球5, b.红球6
- FROM [SELECT a.总期数, a.红球1, a.红球2, a.红球3, a.红球4, a.红球5, a.红球6,"红" & format(a.红球1,"00") as 汇总
- FROM 历史记录 a
- union
- SELECT a.总期数, a.红球1, a.红球2, a.红球3, a.红球4, a.红球5, a.红球6,"红" & format(a.红球2,"00") as 汇总
- FROM 历史记录 a
- union
- SELECT a.总期数, a.红球1, a.红球2, a.红球3, a.红球4, a.红球5, a.红球6,"红" & format(a.红球3,"00") as 汇总
- FROM 历史记录 a
- union
- SELECT a.总期数, a.红球1, a.红球2, a.红球3, a.红球4, a.红球5, a.红球6,"红" & format(a.红球4,"00") as 汇总
- FROM 历史记录 a
- union
- SELECT a.总期数, a.红球1, a.红球2, a.红球3, a.红球4, a.红球5, a.红球6,"红" & format(a.红球5,"00") as 汇总
- FROM 历史记录 a
- UNION
- SELECT a.总期数, a.红球1, a.红球2, a.红球3, a.红球4, a.红球5, a.红球6,"红" & format(a.红球6,"00") as 汇总
- FROM 历史记录 a
- UNION SELECT a.总期数, a.红球1, a.红球2, a.红球3, a.红球4, a.红球5, a.红球6,"蓝" & format(a.蓝球,"00") as 汇总
- FROM 历史记录 a]. AS b
- GROUP BY b.总期数, b.红球1, b.红球2, b.红球3, b.红球4, b.红球5, b.红球6
- PIVOT b.汇总;
复制代码 |