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

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

Question Posted / sudhakar sakthivel

Answer Posted / sudhakar sakthivel

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

in oracle

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How to pass multiple tables in datasets simultaneously?

1068

Give an example that shows how to execute a stored procedure in ado.net?

1077

What are two important objects of ADO.Net?

1031

What is a string variable?

929

Explain the dataadapter class in ado.net?

1217

What is the difference between data reader and data adapter?

1040

Can we connect two dataadapters to same data source using single connection at same time?

993

What is ado control?

960

What are the advantages and drawbacks of using ado.net?

1110

What connected data?

970

Define executenonquery?

920

What does ole stand for in excel?

1155

What is ado circle?

1142

What are typed and untyped dataset?

1112

Why do we use sqldataadapter?

955