【SQL开源代码栏目提醒】:网学会员为需要SQL开源代码的朋友们搜集整理了创建视图.sql相关资料,希望对各位网友有所帮助!
CREATE VIEW v_SumCheck
AS
SELECT SUBSTR(c.CheckDate, 0, 7) AS CheckMonth, e.EmpNAME,
SUM(c.qqDays) AS Sumqq, SUM(c.ccDays) AS SumCc,
SUM(c.bjDays) AS SumBj, SUM(c.sjDays) AS SumSj,
SUM(c.kgDays) AS SumKg, SUM(c.fdxjDays) AS SumFdxj,
SUM(c.nxjDays) AS SumNxj, SUM(c.dxjDays) AS SumDxj,
SUM(c.cdMinutes) AS SumCd, SUM(c.ztMinutes) AS SumZt,
SUM(c.ot1Days) AS SumOt1, SUM(c.ot2Days) AS SumOt2,
SUM(c.ot3Days) AS SumOt3, e.DepId
FROM Checkin c INNER JOIN
Employees e ON c.EmpId = e.EmpId
GROUP BY SUBSTR(c.CheckDate, 0, 7), e.EmpNAME, c.EmpId, e.DepId;