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

How to check if a column is nullable before setting to nullable?

1055

Is sql workbench free?

929

What do we need to check in database testing?

964

What is pl sql block structure?

973

Is sql between inclusive?

1061

What is left join in sql?

1003

how can you see all indexes defined for a table? : Sql dba

934

Is postgresql a server?

995

what is the use of friend function? : Sql dba

970

How can I get the number of records affected by a stored procedure?

999

what is the difference between delete and truncate commands? : Sql dba

995

is it possible to pass an object or table to a procedure as an argument?

1058

what is view? : Sql dba

911

how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba

1292

How many times can we commit in a loop?

955