请救mongoDB大神啊,sql大神啊,现在碰到个蛮烦的sql不知道怎么转换啊。请教转换成java来实现的。
select a.ZSXM_DM,a.ZSXMMC,
SUM(CASE WHEN a.RKRQ >= '2015-01-01' and a.RKRQ<='2015-01-31' THEN SJJE ELSE 0.00 END) AS JE_1Y,
SUM(CASE WHEN a.RKRQ >= '2015-02-01' and a.RKRQ<='2015-02-28' THEN SJJE ELSE 0.00 END) AS JE_2Y,
SUM(CASE WHEN a.RKRQ >= '2015-03-01' and a.RKRQ<='2015-03-31' THEN SJJE ELSE 0.00 END) AS JE_3Y,
SUM(CASE WHEN a.RKRQ >= '2015-04-01' and a.RKRQ<='2015-04-30' THEN SJJE ELSE 0.00 END) AS JE_4Y,
SUM(CASE WHEN a.RKRQ >= '2015-05-01' and a.RKRQ<='2015-05-31' THEN SJJE ELSE 0.00 END) AS JE_5Y,
SUM(CASE WHEN a.RKRQ >= '2015-06-01' and a.RKRQ<='2015-06-30' THEN SJJE ELSE 0.00 END) AS JE_6Y,
SUM(CASE WHEN a.RKRQ >= '2015-07-01' and a.RKRQ<='2015-07-31' THEN SJJE ELSE 0.00 END) AS JE_7Y,
SUM(CASE WHEN a.RKRQ >= '2015-08-01' and a.RKRQ<='2015-08-31' THEN SJJE ELSE 0.00 END) AS JE_8Y,
SUM(CASE WHEN a.RKRQ >= '2015-09-01' and a.RKRQ<='2015-09-30' THEN SJJE ELSE 0.00 END) AS JE_9Y,
SUM(CASE WHEN a.RKRQ >= '2015-10-01' and a.RKRQ<='2015-10-31' THEN SJJE ELSE 0.00 END) AS JE_10Y,
SUM(CASE WHEN a.RKRQ >= '2015-11-01' and a.RKRQ<='2015-11-30' THEN SJJE ELSE 0.00 END) AS JE_11Y,
SUM(CASE WHEN a.RKRQ >= '2015-12-01' and a.RKRQ<='2015-12-31' THEN SJJE ELSE 0.00 END) AS JE_12Y,
SUM(CASE WHEN a.RKRQ >= '2015-01-01' and a.RKRQ<='2015-12-31' THEN SJJE ELSE 0.00 END) AS HJ
from ZS_JKS a where DJXH=000000000033335 AND RKRQ>='2015-01-01'
AND RKRQ<='2015-12-31' GROUP BY ZSXM_DM,ZSXMMC order by ZSXM_DM
搞了半天了,求大神指教