分组问题，请高手指教，再线等待！

[camelzxz]

数据窗口的分组问题，代码如下，但报错[ORA-000936 missing expression]代码如下，请各位高手指点
SELECT INSURANCE.MEDICAL_PAYMENT_MASTER.DATE_OF_PAYMENT,
count(*),
sum(INSURANCE.MEDICAL_PAYMENT_MASTER.TOTAL_COSTS),
sum(INSURANCE.MEDICAL_PAYMENT_MASTER.PAY_FROM_FUND),
sum(INSURANCE.MEDICAL_PAYMENT_MASTER.PAY_FROM_HELP),
sum(INSURANCE.MEDICAL_PAYMENT_MASTER.PAY_OTHER_FEE),
sum(INSURANCE.MEDICAL_PAYMENT_MASTER.PAY_FROM_SUPPLY),
sum(INSURANCE.MEDICAL_PAYMENT_MASTER.PAY_FROM_ACCOUNT),
sum(*),
sum(INSURANCE.MEDICAL_PAYMENT_MASTER.PAY_FROM_ICCARD),
sum(INSURANCE.MEDICAL_PAYMENT_MASTER.PAY_CASH)
FROM INSURANCE.MEDICAL_PAYMENT_MASTER
WHERE ((INSURANCE."MEDICAL_PAYMENT_MASTER"."CLINIC_OR_HOSPITALIZED" = 0) AND
(TO_CHAR(INSURANCE."MEDICAL_PAYMENT_MASTER"."DATE_OF_PAYMENT",'YYYY-MM-DD') >= :start_date) AND
(TO_CHAR(INSURANCE."MEDICAL_PAYMENT_MASTER"."DATE_OF_PAYMENT",'YYYY-MM-DD') < :end_date))
GROUP BY INSURANCE.MEDICAL_PAYMENT_MASTER.DATE_OF_PAYMENT

[killerdanny]

你把这个count(*)取掉试

[camelzxz]

试过，不行的！

[amekoxiao]

sum(INSURANCE.MEDICAL_PAYMENT_MASTER.PAY_FROM_ACCOUNT),
sum(*),
sum(INSURANCE.MEDICAL_PAYMENT_MASTER.PAY_FROM_ICCARD),

去掉上面的sum（*）

[camelzxz]

去掉SUM（*）后，报无效或者不完整的列，count(*)和SUM（*）都去掉，报最初的错误！晕呀！

[camelzxz]

搞定了！谢谢！

[mittee]

sum（*）,这个语法肯定不行的。
我建议你把引号去掉