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

What is ado data control?

528

What is ado code?

510

What are datareaders?

542

What is bubbled event?

546

Explain the difference between data reader and data set?

495

What is an ado connection?

535

What does ado stand for?

529

how can implement dropdownlist in particular of dataset when try to update?

2311

What is csdl entity framework?

565

How to retrieve the user id which is provided while windows authentication?

600

How to identify the controls which can be used for binding data?

557

List the 4 common ado.net namespaces?

699

Which parameter of ConnectionString is used to specify the name of the database?

557

Define Execute Reader?

602

How to generate a single aggregate?

548