SQL 語句提示此處不允許使用分組函數(shù)，是哪里錯(cuò)了，謝謝！

select m_name2,m_period_name,m_segment2, m_description3,m_accounted_cr
, sum(m_accounted_dr)
from gx.cw_mxz_1301 m
where m_description3 like '5501%' and chewing (sum(m_accounted_dr))>1000****)
group by m_name2,m_period_name,m_segment2, m_description3,m_accounted_cr

groupby后面應(yīng)該跟字段名，如果是篩選條件可以使用having關(guān)鍵字

select m_name2,m_period_name,m_segment2, m_description3,m_accounted_cr
,sum(m_accounted_dr)
from gx.cw_mxz_1301 m
where m_description3 like '5501%'
group by m_name2,m_period_name,m_segment2, m_description3,m_accounted_cr
having (sum(m_accounted_dr))>1000****)