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 does the t-sql command ident_incr does? : Transact sql

1083

What is the syntax and use of the coalesce function?

1177

What are pl sql procedures?

1032

Can you rollback after commit?

995

how would concatenate strings in mysql? : Sql dba

1100

What is clustered index sql?

990

How to assign sql query results to pl sql variables?

1086

What is difference between db2 and sql?

1008

What does stand for in sql?

979

How many joins can you have in sql?

941

Do we need to rebuild index after truncate?

1038

How do I debug a stored procedure?

1119

What are the benefits of pl/sql packages?

1107

What is database sql?

1058

how many sql ddl commands are supported by 'mysql'? : Sql dba

1029