Wei Xin

Enthusiastic programmer eager to contribute to team success through hard work, attention to detail and excellent organizational skills. Motivated to learn, grow and excel in Data Analytic field. Strengths in Java, Python, and SQL backed by training in data-related projects.

Row & Column Swap Template

less than 1 minute read

Row_Column_Swap_Template

select A,
-- 第2步，在行列互换结果表中，其他列里的值分别使用case和max来获取
max(case B when 'm' then C else 0 end) as 'm',
max(case B when 'n' then C else 0 end) as 'n'
from cook
-- 第1步，在行列互换结果表中按第1列分组
group by A;