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 the function that is used to transfer a pl/sql table log to a database table?

1029

Which join is default?

958

what is a composite primary key ? : Sql dba

1057

How do I view tables in sql developer?

956

Can we use view in stored procedure?

904

How many types of triggers are there in pl sql?

1069

What does bitemporal mean?

1073

Describe types of sql statements?

1064

Can we insert in view in sql?

1065

How to use distinct and count in sql query? Explain

1030

What are the commands used in sql?

1084

How can we make an if statement within a select statement?

1017

Why is pl sql needed?

956

How do I remove sql plus from windows 10?

1105

How does a self join work?

1132