一个SQL问题//在线等待//谢谢!

Question

求和时要有GOROU BY  的字段，你这里却没有，试下
select hsje,sum (hsje) from (select dj_sn,spbh,spmch,shpgg,shpchd,dw,huowname,pihao,shl,dj,hshj,je,hsje,
koul,shlv,she,gzid,spid,hw,baozhiqi from tmp_dj_xsa220 where gzid='') 
group by hsje
不行就找我吧
QQ：16349893

Answer 1

select sum (hsje) from (select dj_sn,spbh,spmch,shpgg,shpchd,dw,huowname,pihao,shl,dj,hshj,je,hsje,
koul,shlv,she,gzid,spid,hw,baozhiqi from tmp_dj_xsa220 where gzid='')  a//这里加一个表名即可

Answer 2

select sum (a.hsje) from (select dj_sn,spbh,spmch,shpgg,shpchd,dw,huowname,pihao,shl,dj,hshj,je,hsje,
koul,shlv,she,gzid,spid,hw,baozhiqi from tmp_dj_xsa220 where gzid='')
as a