[求助]在关键字 'and' 附近有语法错误。

[az0988]

麻烦高手看看
select cd,spid,ysdm,cmdm,sum(total)as sl from vw_jxchzb where cdlb='sd'group by cd,spid,ysdm,cmdm and rqdate='18'
最后报在关键字 'and' 附近有语法错误。

[山之魂2]

select cd,spid,ysdm,cmdm,sum(total)as sl from vw_jxchzb where cdlb='sd' and rqdate='18'  group by cd,spid,ysdm,cmdm 

[liangCK]

where就where
group就group

select cd,spid,ysdm,cmdm,sum(total)as sl
from vw_jxchzb
where cdlb='sd' and rqdate='18'
group by cd,spid,ysdm,cmdm

[az0988]

谢谢。。语句是过了。。但是

服务器: 消息 241，级别 16，状态 1，行 1
从字符串转换为 datetime 时发生语法错误。

[wzy_love_sly]

select cd,spid,ysdm,cmdm,
sum(total)as sl 
from vw_jxchzb 
where cdlb='sd' and rqdate='18'
group by cd,spid,ysdm,cmdm 

[wzy_love_sly]

select cd,spid,ysdm,cmdm,
sum(total)as sl 
from vw_jxchzb 
where cdlb='sd' and datename(dd,rqdate)='18'
group by cd,spid,ysdm,cmdm 

datename(dd,rqdate) 是日
datename(mm,rqdate) 是月
datename(yy,rqdate) 是年

[kinghb]

select cd,spid,ysdm,cmdm,sum(total) as sl from vw_jxchzb where cdlb='sd' and rqdate='18' group by cd,spid,ysdm,cmdm

group by 应该放在过滤条件之后

[az0988]

谢谢大家，已经有查询结果出来，定义的公式有问题，出的数据不是想要的，但是语句是正确的了~谢谢

[数字化从业者老高]

where 条件要在group by之前。

[-狙击手-]

select cd,spid,ysdm,cmdm,sum(total)as sl
from vw_jxchzb
where cdlb='sd' and rqdate='18'
group by cd,spid,ysdm,cmdm

[cxmcxm]

位置调一下即可

select cd,spid,ysdm,cmdm,sum(total)as sl 
from vw_jxchzb where cdlb='sd' and rqdate='18' group by cd,spid,ysdm,cmdm 

[蜜_Lumia]

学习学习

[heshengfen123]

select cd,spid,ysdm,cmdm,sum(total)as sl from vw_jxchzb where cdlb='sd'and rqdate='18' group by cd,spid,ysdm,cmdm 

[ojuju10]

select cd,spid,ysdm,cmdm,sum(total)as sl from vw_jxchzb where cdlb='sd' and rqdate='18' 
group by cd,spid,ysdm,cmdm