主题：关于SQL分组统计查询的问题

SELECT 客户,SUM(数量) AS 数量，(select count(*) from {订单} as b a.客户=b.客户) as 总数量,() 大额数量 FROM {订单} as a GROUP BY 客户

select 编号, 外币*数量 as 总额 from {订单明细}

 

select * from {订单明细} as a inner join (select 编号, sum(外币*数量) as 总额 from {订单明细} group by 编号) as b on a.编号=b.编号

 

 

参考 http://www.foxtable.com/webhelp/scr/1659.htm

 

 

生成表格后设置列格式 http://www.foxtable.com/webhelp/scr/1659.htm

 

selet 编号, sum(外币*数量) as 总额, 'kg' as 单位 from {订单明细} group by 编号