这个怎么做？看一下。

Question

看一下，关于数据库update语句，也用到了时间的截取，较为复杂

Answer 1

insert into ATTENDANCE (ENO，DATE，FIRSTTIME.LASTTIME) select ENO, trunc(TIME) as DATE,
            min(TIME) as FIRSTTIME,
            max(TIME) as LASTTIME
     from RECORD where trunc(TIME) =  trunc(sysdate)  group by ENO;