求一条比较艰难的SQL语句解决办法

求一条比较艰难的SQL语句

HTML code

数据如下,第一行是列名。以第一条记录解释数据，在GD省GZ市的DuYun销售员一月份(Jan)品牌FA销售的销量是1200，在二月份(Feb)品牌FA的销售量是1800。Province    city    brand    contact    sale    sale_monthGD    GZ    FA    DuYun    1200    JanZJ    HZ    FB    DuanT    1300    JanFJ    FZ    FC    DeMa    1500    JanGD    GZ    FA    DuYun    1800    FebZJ    HZ    FB    DuanT    1900    FebFJ    FZ    FC    DeMa    2000    Feb现在要做出如下的统计表格，分别统计每个销售人员的销售情况。Province    city    brand    contact    Jan    FebGD    GZ    FA    DuYun    1200    1800ZJ    HZ    FB    DuanT    1300    1900FJ    FZ    FC    DeMa    1500    2000

不知道这条语句该怎样写？
请诸位达人指教~~~~~小分送上~~~


[解决办法]
SELECT Province,city,brand,SUM(case when sale_month
='jan' then sale else 0) as jsn ,SUM(case when sale_month
='feb' then sale else 0) as feb

FROM TT GROUP BY Province,city,brand

动态用SP生成SQL语句

[解决办法]

SQL code

select Province,city,brand,contact,    sum(case sale_month when 'Jan' then sale end) as Jan,    sum(case sale_month when 'Feb' then sale end) as Febfrom 数据如下group by Province,city,brand,contact 

 

查看更多 下一篇