|
我写了如下ksql语句,希望同时得的不同erritem的数据记录条数和扣分(degree)的合计
select PB_CheckDetail.fErrItemName as fErrItemName,PB_CheckDetail.fErrItemID as fErrItemID,PB_ErroCatalogue.fCode as fCode,PB_CheckDetail.fErrKindName as fErrKindName,PB_CheckDetail.fErrKindID as fErrKindID,(countAll()) as custom7,(sum( PB_CheckDetail.fDegree )) as custom8
from PB_CheckDetail PB_CheckDetail
join PB_Checks PB_Checks on PB_CheckDetail.fCheckRecordID = PB_Checks
join PB_ErroCatalogue PB_ErroCatalogue on PB_ErroCatalogue = PB_CheckDetail.fErrItemID
group by PB_CheckDetail.fErrKindName, PB_CheckDetail.fErrKindID, PB_CheckDetail.fErrItemName, PB_CheckDetail.fErrItemID, PB_ErroCatalogue.fCode
order by PB_ErroCatalogue.fCode asc
但总是只能得到一个结果,比如上面的语句 custom7和custom8的结果都一样,是记录条数,
在ksql中调换(countAll()) as custom7,(sum( PB_CheckDetail.fDegree )) as custom8的位置,就得到了custom7=custom8=扣分合计。
为什么?
|
|