十分急需解决、、 先谢了、、SQL code: select stuName from Sys_StuInfo where rownum=1 order by stuRegisterTime desc
SQL code: select * from (select stuName from Sys_StuInfo order by stuRegisterTime desc) where rownum=1
这样. ....
SQL code:
-- 也可以这样 select * from Sys_StuInfo where stuRegisterTime=(select max(stuRegisterTime) from Sys_StuInfo) --伪列 select * from Sys_StuInfo where rownum<=1 order by stuRegisterTime desc
CREATE OR REPLACE PROCEDURE usp_refreshTopN IS BEGIN --文档 INSERT INTO topnresource(resourceId,title,type,cover,brief,properUser,tag,clickAmount,createDate,topNCreateDate,organizat ......
