seemu123

 Profile Answers by seemu123 Questions by seemu123

• Jul 1st, 2008

 

You can check it with the help of

SCOPE_IDENTITY( ) function in SQL server 2000 or 2005

biswaranjanbehera

 Profile Answers by biswaranjanbehera 

• Aug 6th, 2008

 

We can select the recent row enrtered by using the query below.
suppose the table name is employee;
then.
select * from employee where rowid=(select max(rowid) from employee).
This works fine because rowid is assigned for each and every record and in accending order. So the recent record's rowid is the man (rowid). Please send feedback with any concern.

biswaranjanbehera

 Profile Answers by biswaranjanbehera 

• Aug 6th, 2008

 

We can get the recent row entered by the help of this query below.

select * from employee where rowid=(select max(rowid) from employee);
because the rowid for the recent row entered in a table is always maximum (though it is stored in accending order).


thanks & regards
Biswaranjan

mv_sivavardhan

 Profile Answers by mv_sivavardhan 

• Aug 6th, 2008

 

select scope_identity
will return the identity value of the last row inserted

malapati

 Profile Answers by malapati 

• Oct 11th, 2008

 

 
select *from<table name> where rowid=(select max(rowid) from <table name>);


for eg:if we are having a table called "CUSTOMER" then;


select *from customer where rowid=(select max(rowid) from customer);   will show the recent entered record

Ashish4oracle

 Profile Answers by Ashish4oracle 

• Mar 23rd, 2009

 

You can try this one query. I am sure this is working fine

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

dachi316

 Profile Answers by dachi316 

• Aug 26th, 2009

 

SCOPE_IDENTITY() would be a better option to get the most recently added row as the primary key for a table may not necessarily be an auto-incrementing variable. Therefore max(rowid) would not be the optimal solution in that case.

bulat

 Profile Answers by bulat 

• May 31st, 2010

 

"Although a rowid uniquely identifies a row in a table, it might change its value if the underlying table is an index organized table or a partitioned table."

Also rowid stores information about physical location of the data, i.e.: file, block and row.

I don't think that there is any guaranty that RowId will be growing as records can get in several different files randomly.