select * FROM (SELECT * FROM TEST ORDER BY ROWNUM DESC ) where rownum <=

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

Question Posted / basanti meher

Answer Posted / basanti meher

select * FROM (SELECT * FROM TEST ORDER BY ROWNUM DESC ) where rownum <=5 ;

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba

1169

How does one load ebcdic data? : aql loader

1150

What is field delimiter?

1034

What is a behavioral trigger?

961

How to order siblings in oracle hierarchy queries?

1021

What is where clause in sql?

1020

What are the packages in pl sql?

999

What is example of database?

1038

Enlist some predefined exceptions?

1037

Is oracel sql developer written in java?

1089

what is the difference between myisam static and myisam dynamic? : Sql dba

1051

The select into statement is most often used to create backup copies of tables or for archiving records?

1055

Are views faster than queries?

977

How does an execution block start and end in pl sql?

927

What are the types pl/sql code blocks?

1109