可以根据group by字段,算出其中一个或多个组合的汇总
SELECT EmpID,,WorkDate
DBNo,GroupName AS ProdLine,COUNT(1) OVER (PARTITION BY DBNo,GroupName,Workdate ) AS CNT, ---CNT表示该生产线每天有多少人参与计件
COUNT(1) OVER (PARTITION BY DBNo,GroupName ) AS CNTByProdLine from A GROUP BY EmpID,DBNo,WorkDate,GroupName