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

Explain what is a subquery ?

852

What is write ahead logging in sql server?

748

How do I write a sql query in pgadmin 4?

712

what is msql? : Sql dba

751

What is sql analyzer?

759

What are joins in sql?

719

What is multiple partition?

696

Is sql database free?

699

How do I delete a trigger?

723

what are the different functions in sorting an array? : Sql dba

766

What is meant by cursor in sql?

725

Which tcp/ip port does sql server run?

715

What is trigger in sql? Explain

700

What is the difference between database trigger and stored procedure?

740

What is oracle pl sql developer?

706