62,046
社区成员
发帖
与我相关
我的任务
分享
select 部门1= case department when '部门1' then 部门1 end,
部门2= case department when '部门2' then 部门2 end,
部门3= case department when '部门3' then 部门3 end,
部门4= case department when '部门4' then 部门4 end,
department
from tables group by department