如果是指年份: create table test_a as (select '19840730' as birth, 'aaa' as name from dual union all select '19840630' as birth, 'bbb' as name from dual union all select '19820730' as birth, 'ccc' as name from dual union all select '19830730' as birth, 'ddd' as name from dual)select substr(birth, 1, 4) birth_year, count(1) from test_a group by substr(birth, 1, 4);
SELECT DATE, SUM(PERSON) FROM TABLENAME GROUP BY DATE
create table test_a
as
(select '19840730' as birth, 'aaa' as name from dual
union all
select '19840630' as birth, 'bbb' as name from dual
union all
select '19820730' as birth, 'ccc' as name from dual
union all
select '19830730' as birth, 'ddd' as name from dual)select substr(birth, 1, 4) birth_year, count(1) from test_a
group by substr(birth, 1, 4);