麻烦高手看看
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' 附近有语法错误。
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' 附近有语法错误。
group就groupselect cd,spid,ysdm,cmdm,sum(total)as sl
from vw_jxchzb
where cdlb='sd' and rqdate='18'
group by cd,spid,ysdm,cmdm
从字符串转换为 datetime 时发生语法错误。
sum(total)as sl
from vw_jxchzb
where cdlb='sd' and rqdate='18'
group by 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) 是年
from vw_jxchzb
where cdlb='sd' and rqdate='18'
group by cd,spid,ysdm,cmdm
select cd,spid,ysdm,cmdm,sum(total)as sl
from vw_jxchzb where cdlb='sd' and rqdate='18' group by cd,spid,ysdm,cmdm
select cd,spid,ysdm,cmdm,sum(total)as sl from vw_jxchzb where cdlb='sd' and rqdate='18'
group by cd,spid,ysdm,cmdm