执行ORACLE SQL语句，报ora-00907 缺少右括号

[litterant]

select slm,substr(id,1,1) lb,sum(zajs) ajsnum,sum(wz) wznum,sum(tzz) tzznum,sum(dt) dtnum from ywk_xmxx join xtwh_struct_class on dh like 'substr(id,1,1)%' where length(slh)=2 and
jgrq>=To_date(2010-7-1 00:00:00,'yyyy-mm-dd hh:mm:ss') and
jgrq<=To_date(2010-10-16 23:59:59,'yyyy-mm-dd hh:mm:ss') group by slm,substr(id,1,1)

请各位大侠帮忙分析下，谢谢

[老之]

两个日期常量用单引号括起来试试

[litterant]

from ywk_xmxx join xtwh_struct_class on dh like 'substr(id,1,1)%'　这语句确实有问题，老是取不到正确值

最终语句为：

select slm,substr(dh,1,3) lb,sum(zajs) ajsnum,sum(wz) wznum,sum(tzz) tzznum,sum(dt) dtnum from ywk_xmxx,xtwh_struct_class where length(slh)=4 and substr(dh,1,3)=substr(id,1,3) and jgrq>=To_date('2001-10-18 00:00:00','yyyy-mm-dd hh24:mi:ss') and jgrq<=To_date('2010-10-18 23:59:59','yyyy-mm-dd hh24:mi:ss') group by slm,substr(dh,1,3)

谢谢各位，结贴

[kye_jufei]

把To_date常量加單引號。。。

[ecjtu5208]

select slm,substr(id,1,1) lb,sum(zajs) ajsnum,sum(wz) wznum,sum(tzz) tzznum,sum(dt) dtnum from ywk_xmxx join xtwh_struct_class on dh like 'substr(id,1,1)%' where length(slh)=2 and  
jgrq>=To_date(2010-7-1 00:00:00,'yyyy-mm-dd hh:mm:ss') and  
 jgrq<=To_date(2010-10-16 23:59:59,'yyyy-mm-dd hh:mm:ss') group by slm,substr(id,1,1)   

[ecjtu5208]

看了一下，于是改成

select slm,substr(id,1,1) lb,sum(zajs) ajsnum,sum(wz) wznum,sum(tzz) tzznum,sum(dt) dtnum from ywk_xmxx join xtwh_struct_class on dh like 'substr(id,1,1)%' where length(slh)=2 and  
jgrq>=To_date(2010-7-1 00:00:00,'yyyy-mm-dd hh:mm:ss') and  
 jgrq<=To_date(2010-10-16 23:59:59,'yyyy-mm-dd hh:mm:ss') group by slm,substr(id,1,1)  

[ecjtu5208]

不好意思，贴了一下，没改

select slm,substr(id,1,1) lb,sum(zajs) ajsnum,sum(wz) wznum,sum(tzz) tzznum,sum(dt) dtnum from ywk_xmxx join xtwh_struct_class on dh like 'substr(id,1,1)%' where length(slh)=2 and  
jgrq>=To_date('2010-7-1 00:00:00','yyyy-mm-dd hh:mm:ss') and  
 jgrq<=To_date('2010-10-16 23:59:59','yyyy-mm-dd hh:mm:ss') group by slm,substr(id,1,1)

[y_zp2010]

[Quote=引用 5 楼 ecjtu5208 的回复:]

SQL code

select slm,substr(id,1,1) lb,sum(zajs) ajsnum,sum(wz) wznum,sum(tzz) tzznum,sum(dt) dtnum from ywk_xmxx join xtwh_struct_class on dh like 'substr(id,1,1)%' where length(slh)=……
[/Quote]
应该是这样的，加上引号

[hongqi162]

oracle to_date应该这样用
to_date('2010-7-1 00:00:00','yyyy-mm-dd hh24:mi:ss')



from ywk_xmxx join xtwh_struct_class on dh like 'substr(id,1,1)%' //问题在这里,这里是什么意思？