在线求汇总

[LiJxin]

select v_b_b_sell_head.corp_code,v_b_b_sell_head.corp_name,v_b_b_sell_head.client_code,v_b_b_sell_head.full_name,convert(varchar(12),count(distinct v_b_b_sell_head.client_code+convert(varchar(14),fill_date,100))) as client_count from v_b_b_sell_head where f_off='0' group by v_b_b_sell_head.corp_code,v_b_b_sell_head.corp_name,v_b_b_sell_head.client_code,v_b_b_sell_head.full_name order by v_b_b_sell_head.corp_code,v_b_b_sell_head.corp_name,v_b_b_sell_head.client_code,v_b_b_sell_head.full_name
corp_code,corp_name,client_code,full_name,client_count,|单位编号;单位名称;客户编号;客户全称;购买次数;
我们公司采用的系统中有一项自定义查询设置，里面能够自定义写SQL语句对数据库进行查询，但上述语句查询的结果中无总计数，求购买次数的总和运算方法。

[LiJxin]

怎么没人理我啊？是不是都不会啊？帮帮我啊。

[paoluo]

首先，你的语句可简写为以下语句，你的太长了

select
corp_code,
corp_name,
client_code,
full_name,
convert(varchar(12),count(distinct client_code+convert(varchar(14),fill_date,100))) as client_count
from v_b_b_sell_head
where f_off='0'
group by
corp_code,
corp_name,
client_code,
full_name
order by
corp_code,
corp_name,
client_code,
full_name

然后你的“查询的结果中无总计数”，指的是所有数据的总数量吗？？

[Well]

你所指的無統計是指什麼方面的呢
可以說明白一些嗎

[duanduan1122]

呵呵。

[xueguang]

合计不难，只要在 GROUP BY 的那些条件后加个 WITH ROLLUP 就行了，不过 ORDER BY 后合计结果可能会出现在最上面

[LiJxin]

自己搞定