sql生成两列数据

SELECT * from UNNEST(ARRAY<STRUCT<lev INT64, power FLOAT64>>[(1, 1),
(2, 1.4), (3, 1.9), (4, 2.5), (5, 3.2), (6, 4), (7, 4.9), (8, 5.9), (9, 7), (10, 8.2), (11, 9.5)])
posted @ 2022-08-19 22:50  luoganttcc  阅读(7)  评论(0)    收藏  举报