select * from (select * from employee order by rowid desc) t where rownum

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

Question Posted / newuser

Answer Posted / newuser

select * from (select * from employee order by rowid desc) t
where rownum<= 5;

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is the purpose of a secondary key?

679

List different type of expressions with the example.

698

What do you know by pl/sql cursors?

759

How does cross join work in sql?

706

What is difference between sql and oracle?

776

Is trigger a stored procedure?

700

How to Execute a Package in PL/SQL.?

807

How to run sql statements through the web interface?

730

what is cursor. write example of it. What are the attributes of cursor.

976

what are the properties and different types of sub-queries? : Sql dba

704

what is a composite key ? : Sql dba

798

What is join view in sql?

698

What are database links used for?

754

What is the maximum number of triggers, you can apply on a single table?

733

Can procedure in package be overloaded?

837