select convert(char(10),出单日期,120) as '出单日期', count(销售单号) as '出单数量',sum(销售单金额) as '销售总金额' from table group by convert(char(10),出单日期,120)
如果一张单据不只一条数据,且每条数据为一条记录 select convert(char(10),出单日期,120) as '出单日期', count(distinct 销售单号) as '出单数量',sum(销售单金额) as '销售总金额' from table group by convert(char(10),出单日期,120)
count(销售单号) as '出单数量',sum(销售单金额) as '销售总金额'
from table
group by convert(char(10),出单日期,120)
select convert(char(10),出单日期,120) as '出单日期',
count(distinct 销售单号) as '出单数量',sum(销售单金额) as '销售总金额'
from table
group by convert(char(10),出单日期,120)