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 file extension for sql database?

983

What are the basic techniques of indexing?

1050

Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?

1027

Does varchar need length?

979

What is the primary key?

935

what are the types of join and explain each? : Sql dba

1024

What are triggers and its types?

1042

Explain scalar functions in sql?

1046

How do I remove all records from a table?

1062

What is clause?

1127

What is sorting in sql?

929

Which join is default?

936

What is the difference between drop and truncate commands?

1046

What is the syntax to add a record to a table?

1072

What is sql and its types?

1157