select * from ( select * from tb_name order by rownum desc ) t where rownum=1;
select * from tb_member_info where mem_id = (select max(tb.mem_id) from tb_member_info tb);
如果表最近没有进行删除操作的话,试试, select * from tb where rowid=(select max(rowid) from tb)
select * from tb_member_info where rowid = ( select max(rowid) from tb_member_info )
select * from tb where id = (select max(id) from tb)
-- 嗯:杨哥的方法老是比我更胜一筹: scott@SZTYORA> select * from emp where rowid=(select max(rowid) from emp); EMPNO ENAME JOB MGR HIREDATE SAL COMM ---------- -------------------- ------------------ ---------- -------------- ---------- ---------- 7934 MILLER CLERK 7782 23-1月 -82 1300已用时间: 00: 00: 00.01
语句: select * from (select a.*,rownum from tb a order by rownum desc) where rownum=1;--例子 SQL> select * from (select a.*,rownum from xs a order by rownum desc) where rownum=1;XH XM ZYM XB CSSJ ZXF ------ -------- -------------------- -- -------------- ---------- BZ -------------------------------------------------------------------------------- ROWNUM ---------- 061241 罗林琳 通信工程 女 30-1月 -86 244 转专业学习 22
select * from tb_name order by rownum desc ) t
where rownum=1;
select *
from tb
where rowid=(select max(rowid) from tb)
where rowid = (
select max(rowid)
from tb_member_info
)
-- 嗯:杨哥的方法老是比我更胜一筹:
scott@SZTYORA> select * from emp where rowid=(select max(rowid) from emp); EMPNO ENAME JOB MGR HIREDATE SAL COMM
---------- -------------------- ------------------ ---------- -------------- ---------- ----------
7934 MILLER CLERK 7782 23-1月 -82 1300已用时间: 00: 00: 00.01
select * from (select a.*,rownum from tb a order by rownum desc) where rownum=1;--例子
SQL> select * from (select a.*,rownum from xs a order by rownum desc) where rownum=1;XH XM ZYM XB CSSJ ZXF
------ -------- -------------------- -- -------------- ----------
BZ
--------------------------------------------------------------------------------
ROWNUM
----------
061241 罗林琳 通信工程 女 30-1月 -86 244
转专业学习
22