是mysql吗?b报表可以这样写:
SELECT bookid,
sum(if(month(saledate)='01',saleqty,0)) as '1月份',
sum(if(month(saledate)='02',saleqty,0)) as '2月份',
sum(if(month(saledate)='03',saleqty,0)) as '3月份',
sum(if(month(saledate)='04',saleqty,0)) as '4月份',
sum(if(month(saledate)='05',saleqty,0)) as '5月份',
sum(if(month(saledate)='06',saleqty,0)) as '6月份',
sum(if(month(saledate)='07',saleqty,0)) as '7月份',
sum(if(month(saledate)='08',saleqty,0)) as '8月份',
sum(if(month(saledate)='09',saleqty,0)) as '9月份',
sum(if(month(saledate)='10',saleqty,0)) as '10月份',
sum(if(month(saledate)='11',saleqty,0)) as '11月份',
sum(if(month(saledate)='12',saleqty,0)) as '12月份',
from bookinfo group by bookid;
SELECT bookid,
sum(if(month(saledate)='01',saleqty,0)) as '1月份',
sum(if(month(saledate)='02',saleqty,0)) as '2月份',
sum(if(month(saledate)='03',saleqty,0)) as '3月份',
sum(if(month(saledate)='04',saleqty,0)) as '4月份',
sum(if(month(saledate)='05',saleqty,0)) as '5月份',
sum(if(month(saledate)='06',saleqty,0)) as '6月份',
sum(if(month(saledate)='07',saleqty,0)) as '7月份',
sum(if(month(saledate)='08',saleqty,0)) as '8月份',
sum(if(month(saledate)='09',saleqty,0)) as '9月份',
sum(if(month(saledate)='10',saleqty,0)) as '10月份',
sum(if(month(saledate)='11',saleqty,0)) as '11月份',
sum(if(month(saledate)='12',saleqty,0)) as '12月份',
from bookinfo group by bookid;
解决方案 »
- mysql中timestamp字段不随该列更新某字段而更改时间~~~要怎么做
- select * into outfile的问题
- 数据库查询问题啊,各位高手指点下
- 这段存储过程中的@strSQL是什么意思?
- Merge表中究竟可以容纳多少个子表,有限制吗?
- MySQL源代码中的tags文件主要是起什么作用??
- MYSQL IN的优化
- 谁知道,我用postgresql数据库连接时不用密码就能连接上了,postgresql的用户是设了密码的.
- 新手问题:怎样使用MySql?
- 想要一个sql语句
- 想问一下,一般的资源下载网站是怎么做的?
- 程序连接postgresql数据只能用localhost连,用IP地址连接或机器名就没有用,请问怎么设置?
sum(if(month(saledate)='01',saleqty,0)) as '1月份',
sum(if(month(saledate)='02',saleqty,0)) as '2月份',
sum(if(month(saledate)='03',saleqty,0)) as '3月份',
sum(if(month(saledate)='04',saleqty,0)) as '4月份',
sum(if(month(saledate)='05',saleqty,0)) as '5月份',
sum(if(month(saledate)='06',saleqty,0)) as '6月份',
sum(if(month(saledate)='07',saleqty,0)) as '7月份',
sum(if(month(saledate)='08',saleqty,0)) as '8月份',
sum(if(month(saledate)='09',saleqty,0)) as '9月份',
sum(if(month(saledate)='10',saleqty,0)) as '10月份',
sum(if(month(saledate)='11',saleqty,0)) as '11月份',
sum(if(month(saledate)='12',saleqty,0)) as '12月份'
from bookinfo group by bookid;