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

麻烦高手看看
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' 附近有语法错误。

...全文

MS-SQL Server 34,876 成员 254,635 内容

切换为时间正序

ojuju10 2008-03-22



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

group by cd,spid,ysdm,cmdm

heshengfen123 2008-03-22

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 2008-03-22

学习学习

cxmcxm 2008-03-21

位置调一下即可

select cd,spid,ysdm,cmdm,sum(total)as sl 

from vw_jxchzb where cdlb='sd' and rqdate='18' group by cd,spid,ysdm,cmdm

-狙击手- 2008-03-21

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

where 条件要在group by之前。

az0988 2008-03-21

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

kinghb 2008-03-21

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 应该放在过滤条件之后

wzy_love_sly 2008-03-21

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) 是年

wzy_love_sly 2008-03-21

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 2008-03-21

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

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

liangCK 2008-03-21

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

山之魂2 2008-03-21

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