sql 行列转置


SELECT country,

SUM( CASE WHEN sex = '1' THEN
population ELSE 0 END) 女,  
SUM( CASE WHEN sex = '0' THEN
population ELSE 0 END) 男   
FROM  Table_A
GROUP BY country;




SELECT country,sum(false) 男,sum(true) 女  
FROM Table_A 
PIVOT (max(population) FOR sex IN(false,true)) p group by country
版权声明：本文为xuebi_ssss原创文章，遵循CC 4.0 BY-SA版权协议，转载请附上原文出处链接和本声明。