我有一个表,要求统计出如下的字段。
表设计:企业代码 int型,金额1 money型,金额2 money型,金额3 money型。
现在要统计的是:比如我有一个企业代码是000001,它有5条记录,要求统计出
金额1的5条记录的中和sum1,金额2的5条记录的中和sum2,金额3的5条记录的中和sum3,如何写sql语句 。
表设计:企业代码 int型,金额1 money型,金额2 money型,金额3 money型。
现在要统计的是:比如我有一个企业代码是000001,它有5条记录,要求统计出
金额1的5条记录的中和sum1,金额2的5条记录的中和sum2,金额3的5条记录的中和sum3,如何写sql语句 。
解决方案 »
- 表内字段根据字段不同做同一个字段的相减
- 淡出+图片背景透明不知如何配合(有代码)
- 一个关于树型菜单操作的问题,大家给我想想用什么方法可以实现。。。。。。。。。。
- SendMessage发送的MSG消息都有什么??怎么查找啊
- 100(5)
- 怎样使由网页上下载的ActiveX控件自动更新?
- 关于Treeview的节点问题,,,,谢谢!
- TStringList.objects[Index] 考贝数据问题
- qtintf.dll 文件是何许东西?怎么delphi的程序运行有的要这个文件,有的可以不要。原因在哪?
- MDIChild在MDI Client 区的移动
- 怎样很容易的得到当前输入法对应的字符串如:'紫光拼音输入法2.2版'?
- 一个数据表之间的关联问题
from tablename
where ....
group by 企业代码--------------------------------------------------------------------
据查证 hammer_shi(@农业专家@(*暂时是菜鸟*))为激进分子,该账号已删除.
我这样 写的
SELECT nsmc,qiyecode,SUM(sp1) AS sumsp,SUM(sp2) AS sumsp2,SUM(sp3) AS sumsp3
SUM(sp4) AS sumsp4
FROM main where nsmc = 'qxx'
group by nsmc,qiyecode
为什么说有错误呢?
SUM(sp4) AS sumsp4SUM(sp3) AS sumsp3 后缺少逗(,)号
from tablename
where 企业代码='000001'
group by 企业代码
SUM(sp3) AS sumsp3, SUM(sp4) AS sumsp4
FROM main
where nsmc = 'qxx'
group by nsmc,qiyecode
begin
Query1.Close;
Query1.SQL.Text :=
'SELECT nsmc,qiyecode,SUM(sp1) AS sumsp,SUM(sp2) AS sumsp2,SUM(sp3) AS sumsp3,'#13#10 +
'SUM(sp4) AS sumsp4,SUM(rk1) AS sumrk1,SUM(rk2) AS sumrk2,SUM(rk3) AS sumrk3,'#13#10 +
'SUM(rk4) AS sumrk4,SUM(qj1) AS sumqj1,SUM(qj2) AS sumqj2,SUM(qj3) AS sumqj3,'#13#10 +
'SUM(qj4) AS sumqj4'#13#10 +
'FROM main'#13#10 +
'where'#13#10 +
if ComboBox3.Text<>'' then
Query1.SQL.Add('nsmc='''+ComboBox3.Text+'''');
if ComboBox4.Text<>'' then
Query1.SQL.Add('AND qiyecode='''+ComboBox4.Text+'''');
Query1.SQL.Add('GROUP BY nsmc,qiyecode');
try
Query1.Open;
ShowMessage('欢迎使用,一共查询到的记录数是:'+IntToStr(Query1.RecordCount));
except
{}
end; Query1.SQL.Add('group by nsmc,qiyecode');
try
Query1.Open;
ShowMessage('欢迎使用,一共查询到的记录数是:'+IntToStr(Query1.RecordCount));
except
{}
end;
end;
还有你的#13,#10是什么意思?
lSQL:String;
begin
lSQL:='SELECT nsmc,qiyecode,SUM(sp1) AS sumsp,SUM(sp2) AS sumsp2,SUM(sp3) AS sumsp3,'+#13+#10 +
'SUM(sp4) AS sumsp4,SUM(rk1) AS sumrk1,SUM(rk2) AS sumrk2,SUM(rk3) AS sumrk3,'+#13+#10 +
'SUM(rk4) AS sumrk4,SUM(qj1) AS sumqj1,SUM(qj2) AS sumqj2,SUM(qj3) AS sumqj3,'+#13+#10 +
'SUM(qj4) AS sumqj4'+#13+#10 +
'FROM main'+#13+#10 +
'where'+#13+#10;
if ComboBox3.Text<>'' then
lSQL:=lSQL+' nsmc='+Char(39)+ComboBox3.Text+Char(39)+')';
if ComboBox4.Text<>'' then
lSQL:=lSQL+' and qiyecode='+Char(39)+ComboBox4.Text+Char(39)+')';
lSQL:=lSQL+' GROUP BY nsmc,qiyecode';
with Query1 do
begin
Close;
SQL.Clear;
SQL.Text:=lSQL;
try
Open;
ShowMessage('欢迎使用,一共查询到的记录数是:'+IntToStr(Query1.RecordCount));
except
{}
end;
end;
end;
from tablename
where 企业代码='000001'
group by m1,m2,m3