求统计每周记录数的SQL语句

select date_col,
to_number(to_char(trunc(sysdate, 'yyyy'), 'd')) year_week_day,
first_day_week,
week_no,
week_no - first_day_week + 1 week_no
from (select date_col,
to_number(to_char(trunc(sysdate, 'mm') + 7 - 1, 'ww')) first_day_week,
to_number(to_char(date_col + 7 - 1, 'ww')) week_no
from (select trunc(sysdate, 'mm') + rownum - 1 date_col
from dba_objects
where rownum <= to_number(to_char(last_day(sysdate), 'dd'))))

执行后，参考。

是指那一周一共有多少条记录的话
表应该有id吧
select count(id) from 表名 between 起始日期 and 最终日期
是这个意思么....