1、现有数据结构
2、行转列后的数据结构
3、SQL语句
SELECT
*
FROM
(
select YEAR,MONTH,cont from v_search_case_count
) as tb1 PIVOT (
MAX (cont) FOR [year] IN (
[2022],[2021],[2020]
)
)
as PVT
ORDER BY cast(MONTH as int) asc
SELECT
*
FROM
(
select YEAR,MONTH,cont from v_search_case_count
) as tb1 PIVOT (
MAX (cont) FOR [year] IN (
[2022],[2021],[2020]
)
)
as PVT
ORDER BY cast(MONTH as int) asc