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

what is “go” in t-sql? : Transact sql

1158

How do I remove all records from a table?

1117

How can I delete duplicate rows?

1063

How you improve the performance of sql*loader? : aql loader

1063

how to include character strings in sql statements? : Sql dba

1138

what are all the different types of indexes? : Sql dba

1104

How many sql are there?

1052

What's the difference between inner join and left join?

1041

What are the constraints available in sql?

1086

What is the advantage of index in sql?

1018

How can you load microsoft excel data into oracle? : aql loader

1216

Define union, minus, union all, intersect ?

1064

what are date and time intervals? : Sql dba

1105

What is a function in oracle pl sql?

1098

what does it mean to have quoted_identifier on? : Sql dba

1181