glakshkar

 Profile Answers by glakshkar 

• Sep 6th, 2007

 

select * from test where rowid = ( select max(rowid) from test);

test is table name. Replace test with appropriate table name.

smitakaushik

 Profile Answers by smitakaushik 

• Sep 18th, 2007

 

Hi!
   I think its best option to view last record added to a table.
  Select * from TableName Order By IdentityFieldName Desc

Enrique

• Sep 23rd, 2007

 

/*
 * How do you view the last record added to a table?
 */
Select Top 1 * from Emp Order By EmpID Desc

hmounir

 Profile Answers by hmounir 

• Jan 6th, 2010

 

select * from
(select * from employees order by rownum desc)
where rownum < 2;

yagneswarasankar

 Profile Answers by yagneswarasankar 

• Nov 23rd, 2010

 

SQL> select  * from name;

no rows selected
  1* insert into name values('Girija')
SQL> /

1 row created.

SQL>  insert into name values('Srinu');

1 row created.

SQL> commit;

Commit complete.
  1* select * from name where rowid = (select max(rowid) from name)
SQL> /

NAME
--------------------
Srinu

nirmal1in

 Profile Answers by nirmal1in Questions by nirmal1in

• Nov 24th, 2010

 

select * from

(select * from test aorder

by a.rowid desc)

where rownum < 2

nirmal1in

 Profile Answers by nirmal1in Questions by nirmal1in

• Dec 28th, 2010

 

We can accomplish this with rowid, below is an example of the query to get the latest inserted records from the table say emp

select * from emp outer where outer.rowid in (
select max(inner.rowid) b from emp inner);

leelakrishna302

 Profile Answers by leelakrishna302 

• Jun 15th, 2012

 

select * from EMP where rowid in (select min(rowid) from EMP);

udit

• Jun 16th, 2014

 

your answer is wrong because min should be replaced with max.

kranthiswaroop

 Profile Answers by kranthiswaroop 

• Jun 16th, 2014

 

Hi ahwaz,

In order to get Last record added to the table, you should first get an idea on table dattype..
1) Whether any sequence no in any column defined which will update when ever row is inserted.
2) will get by retrieving max rowid from the table

himabindu

• Apr 16th, 2018

 

Why use rownum < 2?

Bobby

• Apr 18th, 2018

 

rowid is pseudo column and it can change internally especially on transactional table