表结构:OrderID,FDate,Cust,FAmount
0001 2017-01-01 A 100
0002 2017-01-01 B 200
0003 2017-02-15 A 500
0004 2017-02-16 B 1000
0005 2017-02-16 C 2000
查询结果:
Cust Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
A 100 500
B 200 1000
C 2000
...全文
49回复打赏收藏
1条SQL语句实现按月统计
表结构:OrderID,FDate,Cust,FAmount 0001 2017-01-01 A 100 0002 2017-01-01 B 200 0003 2017-02-15 A 500 0004 2017-02-16 B 1000 0005 2017-02-16 C 2000 查询结果: Cust Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec A 100 500 B 200 1000 C 2000