用SQL实现取员工日工作量和月工作量SELECTCONVERT(char(10), 时间, 120) AS 时间, COUNT(1) AS 日工作量FROM(SELECT DISTINCT BookID, CreatedDate AS 时间, Cr......
用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)
|
