摘要：
select emp_id,name,min(cdatetime),max(cdatetime) from (select *, (select count(*) 'ii' from vwDO_Test b where b.emp_id=a.emp_id and b.cdatetime <=a.cdatetime)ii from vwDO_Test a)c group by emp_id,name,DATEADD(day,-c.ii,cdatetime) having count(*)> =7order by emp_id 阅读全文
