日期:2014-05-17  浏览次数:20506 次

求一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