构造一个sql语句

[churentoudi]

从一张表里面统计出来 同年同月出生的人的数量 如果写这样的一个slq语句 出生日期的格式如：2008－09－01

[worldly_wind]

select count(*) from tablename where to_char(colname,'yyyy-mm') = '2008-09';

[churentoudi]

问题已解决:
select count(substr(to_char(birthday,'yyyy-mm-dd',5,2))) from table group by substr(to_char(birthday,'yyyy-mm-dd',5,2))

[BlueskyWide]

select count(*) from user_table where to_char(birthday,'yyyy-mm-dd')='2008-09-01';

[oracledbalgtu]

例子如下：
SELECT TRUNC(S.HIREDATE, 'mm'), COUNT(*)
  FROM SCOTT.EMP S
 GROUP BY TRUNC(S.HIREDATE, 'mm');

[Quote=引用楼主 churentoudi 的帖子:]
从一张表里面统计出来 同年同月出生的人的数量 如果写这样的一个slq语句 出生日期的格式如：2008－09－01
[/Quote]

[dbcxbj]

select birthday, count(*) from table1 group by birthday order by birthday

[bw555]

select birthday, count(*) from table1 group by birthday having count(*)>1 order by birthday

[zjx2388]

select count(*),birthday from table1 group by birthday order by to_date(birthday,'YYYY-MM-DD')