sql - ORA-00979: 不是 sql developer 中的 GROUP BY 表达式

Question

SELECT DISTINCT
         s.spriden_id,
         swkadfu.goremal_email_address(spriden_pidm,'TAMU','goremal_email_address') AS email,
         sum(tbraccd_amount) 
from tbraccd
  join spriden s on s.spriden_pidm = tbraccd_pidm
           AND s.spriden_ntyp_code = 'UIN'
           AND s.spriden_change_ind = 'I'
group by spriden_id,swkadfu.goremal_email_address
having sum(tbraccd_amount) >='20000';

此查询引发错误。function 和 group by 不会一起去吗？

标签： sqloraclegroup-by

Answer 1

您需要在group by

group by spriden_id, wkadfu.goremal_email_address(spriden_pidm,'TAMU','goremal_email_address')