select * from emp where rowid >( select count(*)-n from emp)

I want to know last five transactions or records from emp
table, from now?

Question Posted / vikram

Answer Posted / vikram

Is This Answer Correct ?

3 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What are the two types of exceptions in pl/sql?

965

What is procedure function?

981

what is bdb (berkeleydb)? : Sql dba

974

What does count (*) do in sql?

952

What is a natural join?

991

what is 'trigger' in sql? : Sql dba

1011

tell us something about heap tables. : Sql dba

1048

Is it possible to read/write files to-and-from PL/SQL?

1035

What is a schema sql?

1053

how can we find the number of rows in a table using mysql? : Sql dba

1029

What is pivot in sql?

871

Why is sharding used?

940

What are the different types of database management systems?

949

What is a sql statement?

900

what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?

2412