用SQL实现取员工日工作量和月工作量

用SQL实现取员工日工作量和月工作量



SELECT CONVERT(char(10), 时间, 120) AS 时间, COUNT(1) AS 日工作量

FROM (SELECT DISTINCT BookID, CreatedDate AS 时间, CreatedByUser AS 姓名
FROM BWK_120BookIn
UNION
SELECT DISTINCT BookID, CreatedDate, CreatedByUser
FROM BWK_120BookIn ) AS t
GROUP BY CONVERT(char(10), 时间, 120)
ORDER BY 时间



select count(*) as 工作量,datename(MM,Createddate) 月 from bwk_120bookin group by datename(MM,Createddate)
GO