Ê®Íò»ð¼±¡¢¡¢Oracle¡¢¡¢ - Oracle / ¿ª·¢

Sys_StuInfo(ѧԱ±í)£º

stuId,stuName,stuLoginId,stuPwd,stuRegisterTime ;ÕâÊÇÀïÃæµÄ×Ö¶Î


ÎÒÏë´ÓÕâ¸ö±íÖвéѯ×î½ü×¢²áµÄÒ»¸öѧԱµÄÐÕÃû¡¢ÈçºÎÀ´²éѯµÄ¡¢£¿£¿

Ê®·Ö¼±Ðè½â¾ö¡¢¡¢
  ÏÈлÁË¡¢¡¢

---

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

ÕâÑù.
....

---

ÒýÓÃ

Sys_StuInfo(ѧԱ±í)£º

stuId,stuName,stuLoginId,stuPwd,stuRegisterTime ;ÕâÊÇÀïÃæµÄ×Ö¶Î


ÎÒÏë´ÓÕâ¸ö±íÖвéѯ×î½ü×¢²áµÄÒ»¸öѧԱµÄÐÕÃû¡¢ÈçºÎÀ´²éѯµÄ¡¢£¿£¿

Ê®·Ö¼±Ðè½â¾ö¡¢¡¢
ÏÈлÁË¡¢¡¢

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

---

ÒýÓÃ

ÒýÓÃÂ¥Ö÷ mabijay µÄ»Ø¸´:
Sys_StuInfo(ѧԱ±í)£º

stuId,stuName,stuLoginId,stuPwd,stuRegisterTime ;ÕâÊÇÀïÃæµÄ×Ö¶Î<