|
#2
lijiao2007-11-16 19:00
|
| 操作员 | 收费金额 | 收费日期 |
| A | 123.32 | 2007-1-1 |
| A | 112.34 | 2007-1-1 |
| A | 101.36 | 2007-1-1 |
| B | 90.38 | 2007-1-1 |
| B | 79.4 | 2007-1-2 |
| C | 68.42 | 2007-1-2 |
| C | 234.56 | 2007-1-2 |
| D | 400.7 | 2007-2-5 |
| D | 566.84 | 2007-2-6 |
| A | 34.56 | 2007-2-6 |
| A | 356.77 | 2007-2-7 |
| ....................................
D xxxx 2007-12-31 有以上数据表，如何用SQL语句查询实现下表 | ||
| 操作员 | 月份 | 收费合计 |
| A | 1 | 337.02 |
| A | 2 | 391.33 |
| A | 3 | xxx |
| A | ……… | xxx |
| A | 12 | xxx |
| B | 1 | 169.78 |
| B | 2 | xxx |
| B | 3 | xxx |
| B | ……… | xxx |
| B | 12 | xxx |
| C | 1 | 302.98 |
| C | 2 | xxx |
| C | 3 | xxx |
| C | ……… | xxx |
| C | 12 | xxx |