数据库查询，分组查询

这是要查的数据所对应的表，下边是sql
SELECT SUM(DECODE
(t.SUBJECT_TYPE,'zc',t.CASH_AMOUNT,0)) AS zcAmount,
SUM(DECODE (t.SUBJECT_TYPE,'fz',t.CASH_AMOUNT,0)) AS fzAmount,
SUM(DECODE (t.SUBJECT_TYPE,'qy',t.CASH_AMOUNT,0)) AS qyAmount,
SUM(DECODE (t.SUBJECT_TYPE,'sr',t.CASH_AMOUNT,0)) AS srAmount,
SUM(DECODE (t.SUBJECT_TYPE,'cb',t.CASH_AMOUNT,0)) AS cbAmount
FROM T_CBPS_ACCOUNT_HIS t where t.ACCOUNT_DATE ='20150909'

问题来了，因为表中account_currency字段是不同的，我现在怎么在根据这个字段在上边的基础上进行分组查询. 而且字段account_currency中的01,12什么的都是从代码中传过来的。谢谢大伙儿。

SELECT Cname ,Grade
FROM SC,Courses
WHERE SC.Cno=Courses.Cno  AND Sno=’2011247’;
SELECT  Students.Sno,Grade
FROM SC,Students
WHERE  Students.Sno=SC.Sno AND  Cno=’CS202’AND Grade>90;
SELECT  Stud......
答案就在这里：数据库分组查询
----------------------你好，人类，我是来自CSDN星球的问答机器人小C，以上是依据我对问题的理解给出的答案，如果解决了你的问题，望采纳。

 SELECT SUM(DECODE
(t.SUBJECT_TYPE,'zc',t.CASH_AMOUNT,0)) AS zcAmount,
SUM(DECODE (t.SUBJECT_TYPE,'fz',t.CASH_AMOUNT,0)) AS fzAmount,
SUM(DECODE (t.SUBJECT_TYPE,'qy',t.CASH_AMOUNT,0)) AS qyAmount,
SUM(DECODE (t.SUBJECT_TYPE,'sr',t.CASH_AMOUNT,0)) AS srAmount,
SUM(DECODE (t.SUBJECT_TYPE,'cb',t.CASH_AMOUNT,0)) AS cbAmount
FROM T_CBPS_ACCOUNT_HIS t where t.ACCOUNT_DATE ='20150909'
GROUP BY  account_currency