mysql - 将列表转换为数据透视表

Question

我正在尝试使用数据透视表结果获取数据以及如何使用数据透视命令转换下面的脚本。

select 
count (escalated_by) as escalated_by,
count (resolved_by) as resolved_by,
count (respond_by) as respond_by,
count (return_by) as return_by,
count (transfer_by) as transfer_by
from dummytable
where reported_date between '2021-06-01' and '2021-06-28'

我想要如下结果。

谢谢

标签： mysqlsqlunpivot

Answer 1

TSQL

select 
  report_this_week, 
  total 
from 
  (
    select 
      Count (escalated_by) as escalated_by, 
      Count (resolved_by) as resolved_by, 
      Count (respond_by) as respond_by, 
      Count (return_by) as return_by, 
      Count (transfer_by) as transfer_by 
    from 
      table 
    where 
      reported_date BETWEEN '2021-06-01' AND '2021-06-28'
  ) as p 
unpivot(
    total for report_this_week in (
      escalated_by, resolved_by, respond_by, 
      return_by, transfer_by
    ) as x