--drop table EMP_LOC
create table EMP_LOC
(ITEMVARCHAR2(25),
LOC NUMBER,
LAST_DATE DATE,
SEQ NUMBER
);
insert into emp_loc (ITEM, LOC, LAST_DATE, SEQ)
values ('111', 22, to_date('12-06-2015 10:46:53', 'dd-mm-yyyy hh24:mi:ss'), 1);
insert into emp_loc (ITEM, LOC, LAST_DATE, SEQ)
values ('111', 22, to_date('12-06-2015 10:46:52', 'dd-mm-yyyy hh24:mi:ss'), 3);
insert into emp_loc (ITEM, LOC, LAST_DATE, SEQ)
values ('111', 22, to_date('12-06-2015 10:46:51', 'dd-mm-yyyy hh24:mi:ss'), 2);
结果:
ITEM
|