我已经实现了你的改变，并试图做更多。我的目标是对access\u history表进行更新，并为这些记录设置processed=1，从而创建emp\u考勤记录集。
当我试图找到最小值（ts）和最大值（ts）时，我得到以下错误
ora-00937：没有单个组功能
当我添加一个组时，我得到一个不同的错误。我发布了带有错误的代码，不知道您能否告诉我如何在同一个查询中完成删除错误并发布更新。

-- Drop table emp_info purge:
-- Drop table locations purge;
-- Drop table access_histoty purge;
-- Drop table emp_attendance purge;
ALTER SESSION SET NLS_DATE_FORMAT = 'MMDDYYYY HH24:MI:SS';
CREATE TABLE employees
(
   employee_id NUMBER(6),
   first_name VARCHAR2(20),
   last_name VARCHAR2(25) NOT NULL,
   card_num varchar2(10)  NOT NULL
);
ALTER TABLE employees
     ADD ( CONSTRAINT employee_id_pk
   PRIMARY KEY (employee_id));
Insert into employees values (1, 'Mike', 'Jones', 'AAA1');
Insert into employees values (2, 'Jane', 'Doe', 'BBB2');
Insert into employees values (3, 'Paul', 'Smith', 'CCC3');
Insert into employees values (4, 'John', 'Henry', 'DDD4');
 Create table locations(
   location_id NUMBER(4),
   location_name varchar2(30),
   location_type char(1));
 -- A=access T=Time & Attendance 
ALTER TABLE locations 
     ADD ( CONSTRAINT lication_id_pk
   PRIMARY KEY (location_id));
Insert into locations values (101, 'South Front Door 1', 'T');
  Insert into locations values (102, 'South Front Door 2', 'T');
  Insert into locations values (103, 'East Back Door 1', 'T');
   Insert into locations values (104, 'East Back Door 2', 'T');
   Insert into locations values (105,'Computer Room', 'A');
   Insert into locations values (106,'1st Floor North',  'A');
Create table access_history(
   employee_id NUMBER(6), 
   card_num varchar2(10),
   location_id number(4),
   Access_date date,
   ts timestamp default systimestamp,
   processed NUMBER(1) default 0
);
INSERT INTO access_history
( employee_id, card_num,
   location_id, Access_date )
 VALUES (1, 'AAA1', 101,    TO_DATE('06212020 21:02:04',  'MMDDYYYY HH24:MI:SS'));
   -- TYpe T no previous data for this
   -- empid record INSERT empid, 
    -- start  time ONLY in table below 
     -- and  update last_start_date  
     -- with DATETIME.
INSERT INTO access_history
( employee_id, card_num,
   location_id, Access_date )
 VALUES (1, 'AAA1', 102,    TO_DATE('06212020 23:52:14',  'MMDDYYYY HH24:MI:SS'));
  -- Type T record empid, start_time
  --  set update end_time only in
  -- emp_attendance.
INSERT INTO access_history
( employee_id, card_num,
   location_id, Access_date )
 VALUES (2, 'BBB2', 103,    TO_DATE('06212020 08:32:35',  'MMDDYYYY HH24:MI:SS'));
 -- TYpe T  INSERT empid, start 
 -- time ONLY in emp_attendance.  
 -- update last_start_date with 
 --  DATETIME on emp_info table
INSERT INTO access_history
( employee_id, card_num,
   location_id, Access_date )
 VALUES (2, 'BBB2', 102,    TO_DATE('06212020 15:39:05',  'MMDDYYYY HH24:MI:SS'));
-- Type T record empid, start_time 
--  set, update end_time only in
-- emp_attendance.
INSERT INTO access_history
( employee_id, card_num,
   location_id, Access_date )
 VALUES (3, 'CCC3', 103,    TO_DATE('06212020 15:39:05',  'MMDDYYYY HH24:MI:SS'));
 -- TYpe T  INSERT empid, start 
 -- time ONLY in emp_attendance.  
 -- update last_start_date with 
 --  DATETIME on emp_info table
INSERT INTO access_history
( employee_id, card_num,
   location_id, Access_date )
 VALUES (3, 'CCC3', 105,    TO_DATE('06212020 18:19:55',  'MMDDYYYY HH24:MI:SS'));
-- Type A record don't do anything to 
-- emp_attendance.
INSERT INTO access_history
( employee_id, card_num,
   location_id, Access_date )
 VALUES (4, 'DDD4', 102,    TO_DATE('06212020 08:49:35',  'MMDDYYYY HH24:MI:SS'));
--  single record with no pair. Set
-- end_date to start_date if end_date
-- is NULL
INSERT INTO access_history
( employee_id, card_num,
   location_id, Access_date )
 VALUES (3, 'CCC3', 104,    TO_DATE('06222020 04:04:35',  'MMDDYYYY HH24:MI:SS'));
-- Type T record empid, start_time 
--  set, update end_time only in
-- emp_attendance.
 CREATE TABLE  emp_attendance    
  (seq_num NUMBER(10),
   employee_id NUMBER(6),
   start_date DATE,
   end_date DATE,
   create_date DATE DEFAULT SYSDATE
   );
   Create sequence emp_attendance_seq;
   insert into emp_attendance.   
     (seq_num, 
       employee_id, 
       start_date, 
      end_date)
   with
   -- error capturing min,max ts
   --
   prep (min_ts, max_ts, employee_id, start_date, rn, end_date) as (
     select MIN(ts), MAX(ts), employee_id, access_date
        , row_number()      over (partition by card_num order by access_date)
      , lead(access_date) over (partition by card_num order by access_date)
   from   access_history
 where  location_id in ( select location_id
                     from   locations
                      where  location_type = 'T'
                  )
                  AND processed = 0
  )
   select emp_attendance_seq.nextval,
      employee_id,
     start_date,
   nvl(end_date, start_date)
  from prep
 where  mod(rn, 2) = 1;