Question

plsql中执行没有错误，但是在c#中去执行抛出错误 求大神指导 下面是具体sql语句

select zldwdm,dl,sum(mj) from (select zldwdm,substr(dlbm,1,2) as dl,sum(mj3) as mj from where substr(zldwdm,1,9)='123456789' and nf=2009 group by zldwdm, dlbm order by zldwdm, dlbm) group by zldwdm,dl order by zldwdm,dl
这个语句在plsql中运行没有出错，而且能出正确的结果。但是在C#中执行这sql语句会出现“语法错误：应为标示符或带引号的标示符”
非常感谢你们耐心的回答，我已经找到了问题所在了，不是sql语句的问题。
是第一次查询出来的结果中没有带关键字
但是missingSchemaAction的属性设置了AddWithKey。

Answer 1

select zldwdm,dl,sum(mj) from (select zldwdm,substr(dlbm,1,2) as dl,sum(mj3) as mj from where substr(zldwdm,1,9)='123456789' and nf=2009 group by zldwdm, dlbm order by zldwdm, dlbm) group by zldwdm,dl order by zldwdm,dl

'123456789' 这个要放在C# 语法中 不能直接写，要进行转换 ，或者在

string str=@“select zldwdm,dl,sum(mj) from (select zldwdm,substr(dlbm,1,2) as dl,sum(mj3) as mj from where substr(zldwdm,1,9)='123456789' and nf=2009 group by zldwdm, dlbm order by zldwdm, dlbm) group by zldwdm,dl order by zldwdm,dl”

Answer 2

写成这样试试。
“select zldwdm,dl,sum(mj) from (select zldwdm,substr(dlbm,1,2) as dl,sum(mj3) as mj from where substr(zldwdm,1,9)='“+123456789+”' and nf=2009 group by zldwdm, dlbm order by zldwdm, dlbm) group by zldwdm,dl order by zldwdm,dl”

Answer 3

'123456789'这句话改为“123456789”你再试试看！