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 trigger explain with example?

1092

State few characteristics of pl/sql?

1023

How do I kill a query in postgresql?

1188

What is difference sql and mysql?

1037

what are the differences between binary and varbinary? : Sql dba

1085

What is trigger in sql and its types?

1113

What is trigger price?

1048

What is pl sql block structure?

1095

What are transaction and its controls?

1089

Can we use commit inside a trigger?

1147

what are the advantages of mysql in comparison to oracle? : Sql dba

1048

What are primary key and foreign key and how they work?

1018

Which kind of parameters cannot have a default value in pl sql?

1212

What is record in pl sql?

1140

Explain ttitle and btitle.

1165