ORA-00936:缺失表达式Teradata

Question

我在识别代码中的问题所在时遇到了困难。任何帮助都将不胜感激。使用Teradata，它将返回错误“选择失败。ORA-00936:缺失表达式”。

SELECT

,CR.CLAIMNUMBER 
,CR.LINENUMBER  
,SUBSTR(CLM.SUBMITTERCLAIMNUMBER,3,11) AS CLM_NBR
,CR.SEQNUMBER   
,MAX(CR.SEQNUMBER) AS MAX_SEQ 
,CR.VOLUME  
,CR.VOLUMETYPE  
,CR.RATE    
,CR.RATETYPE    
,CR.ALLOWED     
FROM PRICER.CLMREPRICINGDETAIL CR   
INNER JOIN PRICER.CLMCLAIMS CLM ON  CLM.CLAIMNUMBER = CR.CLAIMNUMBER    
INNER JOIN PRICER.CLMCLAIMITEMS CLMP ON CLM.CLAIMNUMBER = CLMP.CLAIMNUMBER AND CLM.OWNERID = CLMP.OWNERID   
INNER JOIN PRICER.CLMINSURED CLMI ON CLM.CLAIMNUMBER = CLMI.CLAIMNUMBER AND CLM.OWNERID = CLMI.OWNERID  

WHERE TRADEPARTNERID IN ('NationalNonHouse','NationalHouse')

AND SUBSTR(CLM.SUBMITTERCLAIMNUMBER,3,11) IN ('17304CD2083','17297CA4107')  
group by 1,2,3,4,5,6,7,8,9,10   
having CR.SEQNUMBER =  MAX_SEQ 
;

Answer 1

我会在选择后删除逗号：

SELECT CR.CLAIMNUMBER 
, CR.LINENUMBER  
, SUBSTR(CLM.SUBMITTERCLAIMNUMBER,3,11) AS CLM_NBR
, CR.SEQNUMBER   
, MAX(CR.SEQNUMBER) AS MAX_SEQ 
, CR.VOLUME  
, CR.VOLUMETYPE  
, CR.RATE    
, CR.RATETYPE    
, CR.ALLOWED     
FROM PRICER.CLMREPRICINGDETAIL CR   
INNER JOIN PRICER.CLMCLAIMS CLM ON  CLM.CLAIMNUMBER = CR.CLAIMNUMBER    
INNER JOIN PRICER.CLMCLAIMITEMS CLMP ON CLM.CLAIMNUMBER = CLMP.CLAIMNUMBER AND CLM.OWNERID = CLMP.OWNERID   
INNER JOIN PRICER.CLMINSURED CLMI ON CLM.CLAIMNUMBER = CLMI.CLAIMNUMBER AND CLM.OWNERID = CLMI.OWNERID  

WHERE TRADEPARTNERID IN ('NationalNonHouse','NationalHouse')
AND SUBSTR(CLM.SUBMITTERCLAIMNUMBER,3,11) IN ('17304CD2083','17297CA4107')  
group by 1,2,3,4,5,6,7,8,9,10   
having CR.SEQNUMBER =  MAX_SEQ;