SELECT
COUNT (ID) 人数,
BD 生日
FROM
(
SELECT
ROW_NUMBER () OVER (
PARTITION BY SUBSTR (AAC002, 11, 4)
ORDER BY
SUBSTR (AAC002, 11, 4)
) id, SUBSTR (AAC002, 11, 4) BD
FROM
GLOBAL_COMPANY_USRINFO
WHERE
SUBSTR (AAC002, 11, 4) BETWEEN '0101'
AND '0131'
) T
GROUP BY
BD
ORDER BY
BD
结果: