How to get the most recently added/updated record from a table?

Questions by mkatpatal   answers by mkatpatal

Showing Answers 1 - 3 of 3 Answers

kiran prajapati

  • Aug 4th, 2006
 

The SQL Server global @@IDENTITY variable contain the value of an Identity column after a row has been inserted.

  Was this answer useful?  Yes

mukund

  • Aug 5th, 2006
 

I require this for the oracle 

  Was this answer useful?  Yes

kiran prajapati

  • Aug 6th, 2006
 

you can use the "rownum" column of the table. like

select max(rownum) from tableName.

select * from tableName where rownum = (fetched rownum)

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions