能否在query中统计数据？？？(50分)

H

hfjacklee

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-06-05

• #1

是这样的我先用query1统计出一张表格现在我想把query1中的某个字段汇总（sum），该怎么办？？
不要用循环累加！能否用类似query2.sql.add(select sum(xsje) from query1);这样的简洁方法？？

 

完

完颜康

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-06-05

• #2

这样写试不可以的，
你想实现什么功能？

 

三

三石

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-06-05

• #3

不知你用的是什么数据库，若支持嵌套查询的话，
那么第二个query用嵌套查询就可以了
query2.sql.text:='select sum(xsje) from (******) ';
//＊＊＊＊＊处写上你的query1中的语句。
不知能不能达到你要的功能

 

M

myjane

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-06-05

• #4

select AA,sum(xsje) from query1 group by AA
AA是你在汇总的字段。

 

H

hfjacklee

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-06-06

• #5

我按照“三石”的方法输入下面的语句，可是报【incorrect syntax near ')'】
select sum(销售总金额) from (select tm as 商品条码,hh as 货号,dpmc as 商品名称,ghsdh as 供货商,gzdh as 部门,lbdh as 柜组,xl as 零售销量,pfxl as 批发销量,tgxl as 团购销量,zxl as 总销量,sj as 零售价,lsje as 零售金额,pfje as 批发金额,tgje as 团购金额,xsje as 销售总金额,ml as 毛利,hhjj as 含税进价,jjzje as 进价总金额,hjkcl as 商场库存量,hjkcje as 商场库存金额 from db20020518 where zxl<>0)

 

Z

zyf23

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-06-06

• #6

正在反闹！


帮助提前！

 

S

skimeister

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-06-06

• #7

select sum(xsje) as 销售总金额 from db20020518 where zxl<>0