SELECT * FROM V_CJGL_XSCJ
PIVOT
(
max(zhcj ) FOR
xnxq IN ('2015-2016-1')
)
SELECT * FROM V_CJGL_XSCJ
PIVOT
(
max(zhcj ) FOR
xnxq IN ('2015-2016-1')
)
1
zxCoder May 19, 2021
子查询吗?
这是啥 |
2
zhangzhiming OP PIVOT
@zxCoder PIVOT 行转列 |
3
wellsc May 19, 2021
子查询呗
|
4
zhangzhiming OP @wellsc 大兄弟里面不能写 select
|
5
raaaaaar May 19, 2021 via Android
。。额,这是 SQL 么,咋看不懂
|