Select OneItem,Sum(ZJGCF) as ZJGCF,Sum(CSF) as CSF, Sum(JJF) as JJF,Sum(LR) as LR,Sum(SJ) as SJ From (Select 定额编号 As DEBH,Sum(总费用) as ZJGCF ,CSF,JJF,LR,SJ,OneItem From ZJGCFB, (Select 定额编号 As DEBH,Sum(总费用) as CSF From ZJGCFB Where 费用名称='措施费' group by 定额编号) as A, (Select 定额编号 As DEBH,Sum(总费用) as JJF From ZJGCFB Where 费用名称='间接费' group by 定额编号) as B, (Select 定额编号 As DEBH,Sum(总费用) as LR From ZJGCFB Where 费用名称='项目利润'group by 定额编号) as C, (Select 定额编号 As DEBH,Sum(总费用) as SJ From ZJGCFB Where 费用名称='税金' AND 费用单位='元' group by 定额编号) as D, (Select DISTINCT RAtionNo,OneItem From ItemRationList ) as E Where 费用名称='直接工程费' AND ZJGCFB.定额编号=A.DEBH AND ZJGCFB.定额编号=B.DEBH AND ZJGCFB.定额编号=C.DEBH AND ZJGCFB.定额编号=D.DEBH and ZJGCFB.定额编号=E.RAtionNo group by 定额编号,总费用,CSF,JJF,LR,SJ,OneItem) AS HZ Group by OneItem
我用过的一个SQL查询,呵呵`你看看吧。可能对你有帮助,组合查。在Sum
查询语句 query1.close; query1.sql.clear; query1.sql.add('select name,price from yourtable'); query1.open; s:=0.0 while not query1.eof do begin s:=s+query1.filedbyname('price').asfloat; query1.next; end label1.caption:=s;
对不起,我没表达清楚 我是想先查询出来品名和价格 再把查询的价格进行求和 然后再把求出来的总价格显示在label上! 呵呵~你还是没有表达清楚哦。不知道你是要每种品名的和还是所有的总合? 如是每种的那就 Select 品名,Sum(价格) as 别名 From 表 Groud by 品名 如是全部的 Select Sum(价格) as 别名 From 表
我是想先查询出来品名和价格
再把查询的价格进行求和
然后再把求出来的总价格显示在label上!
(Select 定额编号 As DEBH,Sum(总费用) as ZJGCF ,CSF,JJF,LR,SJ,OneItem From ZJGCFB,
(Select 定额编号 As DEBH,Sum(总费用) as CSF From ZJGCFB Where 费用名称='措施费' group by 定额编号) as A,
(Select 定额编号 As DEBH,Sum(总费用) as JJF From ZJGCFB Where 费用名称='间接费' group by 定额编号) as B,
(Select 定额编号 As DEBH,Sum(总费用) as LR From ZJGCFB Where 费用名称='项目利润'group by 定额编号) as C,
(Select 定额编号 As DEBH,Sum(总费用) as SJ From ZJGCFB Where 费用名称='税金' AND 费用单位='元' group by 定额编号) as D,
(Select DISTINCT RAtionNo,OneItem From ItemRationList ) as E
Where 费用名称='直接工程费' AND ZJGCFB.定额编号=A.DEBH AND ZJGCFB.定额编号=B.DEBH
AND ZJGCFB.定额编号=C.DEBH AND ZJGCFB.定额编号=D.DEBH and ZJGCFB.定额编号=E.RAtionNo
group by 定额编号,总费用,CSF,JJF,LR,SJ,OneItem) AS HZ
Group by OneItem
query1.close;
query1.sql.clear;
query1.sql.add('select name,price from yourtable');
query1.open;
s:=0.0
while not query1.eof do
begin
s:=s+query1.filedbyname('price').asfloat;
query1.next;
end
label1.caption:=s;
我是想先查询出来品名和价格
再把查询的价格进行求和
然后再把求出来的总价格显示在label上!
呵呵~你还是没有表达清楚哦。不知道你是要每种品名的和还是所有的总合?
如是每种的那就
Select 品名,Sum(价格) as 别名 From 表 Groud by 品名
如是全部的
Select Sum(价格) as 别名 From 表