select 员工编号,姓名,物料名,工序号,工序名,sum(工费/工序),SUM(数量),SUM(耗时),SUM(工费合计) FROM TABLENAME GROUP BY 员工编号,姓名,物料名,工序号,工序名
select * from ( select * from tb union all select 员工编号,'','','','合计',工费/工序 = sum(工费/工序), 数量 = sum(数量),耗时 = sum(耗时),工费合计 = sum(工费合计) FROM tb group by 员工编号,姓名,物料名,工序号,工序名 ) t order by 员工编号
select CASE WHEN (GROUPING(员工编号) = 1) THEN '合计' ELSE ISNULL(员工编号, 'UNKNOWN') END AS 员工编号, 工费/工序 = sum(工费/工序), 数量 = sum(数量) ,耗时 = sum(耗时), 工费合计 = sum(工费合计) FROM tb group by 员工编号 with rollup试试这一句
select 员工编号,姓名,物料名,工序号,工序名,sum(工费/工序),SUM(数量),SUM(耗时),SUM(工费合计) FROM TABLENAME
GROUP BY 员工编号,姓名,物料名,工序号,工序名
(
select * from tb
union all
select 员工编号,'','','','合计',工费/工序 = sum(工费/工序),
数量 = sum(数量),耗时 = sum(耗时),工费合计 = sum(工费合计) FROM tb
group by 员工编号,姓名,物料名,工序号,工序名
) t order by 员工编号
CASE WHEN (GROUPING(员工编号) = 1) THEN '合计' ELSE ISNULL(员工编号, 'UNKNOWN') END AS 员工编号,
工费/工序 = sum(工费/工序),
数量 = sum(数量)
,耗时 = sum(耗时),
工费合计 = sum(工费合计)
FROM tb
group by 员工编号 with rollup试试这一句