当前位置: 代码迷 >> Sql Server >> 求1sql语句,
  详细解决方案

求1sql语句,

热度:39   发布时间:2016-04-24 21:04:25.0
求一sql语句,急!!!
Id          price       time
----------- ----------- -----------------------
...
1           87          2013-01-08 16:31:15.000
2           140         2013-01-09 09:05:14.000
3           44          2013-02-09 09:05:14.000
4           12          2013-03-09 09:05:14.000
5           31          2013-04-09 09:05:14.000
6           525         2013-05-09 09:05:14.000
7           188         2013-06-13 09:12:46.000
...
...
...


我想查出详细+每个月总和+到这个月总和,有什么好方法,求大神。。。

编号          价格          时间
----------- -----------    -----------------------
1           87             2013-01-08 16:31:15.000
2           140            2013-01-09 09:05:14.000
            本月小结:227    2013-01-31
            累计:227       2013-01-31
3           44             2013-02-09 09:05:14.000
            本月小结:44     2013-02-28
            累计:271       2013-02-28
4           12             2013-03-09 09:05:14.000
            本月小结:12     2013-03-31
            累计:283       2013-03-31
  相关解决方案