select
count(case when (LIBRARY_TYPE='论文' and TO_CHAR(CREATE_TIME, 'YYYY-MM')=#{year} || '-01') then 1 else null end) A,
count(case when (LIBRARY_TYPE='论文' and TO_CHAR(CREATE_TIME, 'YYYY-MM')=#{year} || '-02') then 1 else null end) B,
count(case when (LIBRARY_TYPE='论文' and TO_CHAR(CREATE_TIME, 'YYYY-MM')=#{year} || '-03') then 1 else null end) C,
count(case when (LIBRARY_TYPE='论文' and TO_CHAR(CREATE_TIME, 'YYYY-MM')=#{year} || '-04') then 1 else null end) D,
count(case when (LIBRARY_TYPE='论文' and TO_CHAR(CREATE_TIME, 'YYYY-MM')=#{year} || '-05') then 1 else null end) E,
count(case when (LIBRARY_TYPE='论文' and TO_CHAR(CREATE_TIME, 'YYYY-MM')=#{year} || '-06') then 1 else null end) F,
count(case when (LIBRARY_TYPE='论文' and TO_CHAR(CREATE_TIME, 'YYYY-MM')=#{year} || '-07') then 1 else null end) G,
count(case when (LIBRARY_TYPE='论文' and TO_CHAR(CREATE_TIME, 'YYYY-MM')=#{year} || '-08') then 1 else null end) H,
count(case when (LIBRARY_TYPE='论文' and TO_CHAR(CREATE_TIME, 'YYYY-MM')=#{year} || '-09') then 1 else null end) I,
count(case when (LIBRARY_TYPE='论文' and TO_CHAR(CREATE_TIME, 'YYYY-MM')=#{year} || '-10') then 1 else null end) J,
count(case when (LIBRARY_TYPE='论文' and TO_CHAR(CREATE_TIME, 'YYYY-MM')=#{year} || '-11') then 1 else null end) K,
count(case when (LIBRARY_TYPE='论文' and TO_CHAR(CREATE_TIME, 'YYYY-MM')=#{year} || '-12') then 1 else null end) L
from ZT_JSZLB_KJZBWCL_LIBRARY
今天看了一个sql是oracle数据库里的,之前学过mysql数据库,百度了之后发现是连接的意思,可以把两个字段拼接
这里就等于年+月