How to fetch the last inserted record in a particular table?

Categories >> Software >> Microsoft Related >> ADO.NET
Suggest New Category

Question Posted / raji22559

10 Answers
19112 Views
CarrizalSoft Technologies, Microsoft, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How to fetch the last inserted record in a particular table?..

Answer / vimal katiyar

daer Archana your answer is nt complete so this s complete query fr last inserted record fetch from table

select * from <tablename> where id=(select max(id) from <table name>)

Is This Answer Correct ?

32 Yes

2 No

How to fetch the last inserted record in a particular table?..

Answer / raji22559

CommanObject.CommandText="Select @@Identity";

** Note: Over a given connection if any insert statement is
executed on a table with identity column , the back end
sql-server for the connection initializes a parameter by
name "@@Identity" with the value of Identity column for the
last inserted record.

Is This Answer Correct ?

18 Yes

8 No

How to fetch the last inserted record in a particular table?..

Answer / skumar

We can use the query like
SELECT TOP 1 ID FROM table ORDER BY ID DESC

Is This Answer Correct ?

11 Yes

2 No

How to fetch the last inserted record in a particular table?..

Answer / nitin kaushik

"select @@identity"
@@identity is used to get the current transaction value .

** Note: Over a given connection if any insert statement is
executed on a table with identity column , the back end
sql-server for the connection initializes a parameter by
name "@@Identity" with the value of Identity column for the
last inserted record.

Is This Answer Correct ?

9 Yes

1 No

How to fetch the last inserted record in a particular table?..

Answer / jk

By using scope_identity

Is This Answer Correct ?

9 Yes

2 No

How to fetch the last inserted record in a particular table?..

Answer / sudhakar sakthivel

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

in oracle