select t.CREATE_TIME from table_name t where rownum = 1 order by t.CREATE_TIME desc;
正确的写法:
select * from (select t.* from LMS_PROCESS_CHECK t order by t.CREATE_TIME desc) where rownum = 1;
select t.CREATE_TIME from table_name t where rownum = 1 order by t.CREATE_TIME desc;
正确的写法:
select * from (select t.* from LMS_PROCESS_CHECK t order by t.CREATE_TIME desc) where rownum = 1;