Oracle 如何统计一到周五的数据，每天至少一条，进行分类提交与未提交

统计一到周五的数据，每天至少一条，进行分类提交与未提交，有指定时间段

select * from 表名 where WeekDay(日期字段) -1 between 1 and 5
--其中WeekDay是求日期是周几的一个函数，但是按照外国，是从星期日开始算每周的第一天，所以要减去1
分类的话使用 group 即可

select t.zj "周几", t.分类 "分类", count(1) "记录"
from (select t.*
from (select to_number(to_char(日期字段, 'D')) - 1 as zj, t.*
from 表名 t
where 日期字段 between 开始日期 and 结束日期) t
where t.zj between 1 and 5) t
group by t.zj, t.分类;

select a.weekday,b.*
(select level weekday from dual
connect by level<=5) a,
(select to_number(to_char(datafield,'D'))) weekday,sum(***)
from xxxx
where datafield between xxxx and xxx
group by to_number(to_char(datafield,'D')))) b
where a.weekday=b.weekday