select stuName from Sys_StuInfo where rownum=1 order by stuRegisterTime desc
select * from (select stuName from Sys_StuInfo order by stuRegisterTime desc) where rownum=1 这样. ....
-- 也可以这样 select * from Sys_StuInfo where stuRegisterTime=(select max(stuRegisterTime) from Sys_StuInfo) --伪列 select * from Sys_StuInfo where rownum<=1 order by stuRegisterTime desc
貌似这样也可以啊、、select stu_name from sys_stuinfo where stu_registertime in (select max(stu_registertime) from sys_stuinfo)解决了、、 谢谢大侠、、
from Sys_StuInfo
where rownum=1
order by stuRegisterTime desc
from Sys_StuInfo
order by stuRegisterTime desc)
where rownum=1
这样.
....
select * from Sys_StuInfo
where stuRegisterTime=(select max(stuRegisterTime) from Sys_StuInfo)
--伪列
select * from Sys_StuInfo
where rownum<=1
order by stuRegisterTime desc
(select max(stu_registertime) from sys_stuinfo)解决了、、
谢谢大侠、、