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;

 

 

 

 

版权声明：本文为qq_37375667原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
原文链接：https://blog.csdn.net/qq_37375667/article/details/111603349