当月累计和年累计的记录数不会相同,并且没有连接,修改如下
SELECT A.GS,B.Y_COUNT,A.M_COUNT FROM
(SELECT COUNT(*) M_COUNT, GS
FROM 考勤记录表 T
WHERE TO_CHAR(T.创建时间, 'YYYY-MM') = TO_CHAR(SYSDATE, 'YYYY-MM')
GROUP BY GS) A,
(SELECT COUNT(*) Y_COUNT, GS
FROM 考勤记录表 T
WHERE TO_CHAR(T.创建时间, 'YYYY') = TO_CHAR(SYSDATE, 'YYYY')
GROUP BY GS)B
WHERE A.GS=B.GS
SELECT A.GS,B.Y_COUNT,A.M_COUNT FROM
(SELECT COUNT(*) M_COUNT, GS
FROM 考勤记录表 T
WHERE TO_CHAR(T.创建时间, 'YYYY-MM') = TO_CHAR(SYSDATE, 'YYYY-MM')
GROUP BY GS) A,
(SELECT COUNT(*) Y_COUNT, GS
FROM 考勤记录表 T
WHERE TO_CHAR(T.创建时间, 'YYYY') = TO_CHAR(SYSDATE, 'YYYY')
GROUP BY GS)B
WHERE A.GS=B.GS
我也不想那么复杂的.业务需要,作为码农的我.只能默默服从