Select org, count (*) cou,substr(nvl(avg(ttt),0),0,5)*24*60*1000000/1000000 avgmin,to_char(endtime,'yyyy/MM/dd') day
from (
select doc_id, department org, starttime,(endtime - (lag(endtime) over (partition by doc_id order by doc_id,endtime))) ttt,endtime, isfinish from mochabsm.bsm_t_doctransact
where 1>0 and
department in(
select t.name from mochabsm.bsm_t_oa_organization t
where t.code in( '001002', '001003', '001004', '001005', '001006', '001007', '001008', '001009', '001010', '001011', '001012', '001013', '001014', '001015', '001016', '001017', '001018', '001019', '001020', '001021', '001022', '001023'))) t
group by org,to_char(endtime,'yyyy/MM/dd')
order by org

－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－

over (partition by doc_id order by doc_id,endtime)

这句话主要代表什么意思，谢谢大哥们了，