当前位置: 代码迷 >> Sql Server >> 统计某几行几列中数据的 个数解决方案
  详细解决方案

统计某几行几列中数据的 个数解决方案

热度:84   发布时间:2016-04-24 09:52:14.0
统计某几行几列中数据的 个数
现有如下表:
id GoodsInfo FactoryPrice   WholePrice         RetailPrice      company         time

1  尿素                  1                   2                            3                 gong            2014
2  碳铵                  0                  0                               5                 gong           2014
3  普通钙                0                   0                            1                 gong           2014
4  尿素                 2                   2                            0                 si                   2014
5  碳铵                  0                  0                                0                si                  2014
6  普通钙            0                   0                             0                si                  2014
7  尿素                 2                   0                            0                 gong            2013
8  碳铵                  0                  4                                0                gong            2013
9  普通钙            0                   3                             3               gong             2013
 
需要统计company各时间段的price>0的个数
得到如下结果

company    num     time
gong            5          2014
si                  2          2013
gong           4           2013


------解决思路----------------------
  相关解决方案