从一列创建多列

该过程称为枢转。一种方法是：

 select  Country ,       sum(case when Month = 'June' then Number end) as June ,       sum(case when Month = 'May' then Number end) as May ,       sum(case when Month = 'April' then Number end) as April from    YourTable group by         Country