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

Answer Posted / newuser

select * from (select * from employee order by rowid desc) t
where rownum<= 5;

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is dbo in sql?

617


What are the types of optimization?

605


what is the difference between where clause and having clause? : Sql dba

626


What is a heap in sql?

623


What is the difference between sum and count in sql?

609






What is interval partition?

626


What jobs use sql?

613


What is the use of triggers?

630


How do I remove sql developer from windows 10?

601


What is a nested table in word?

614


How does a self join work?

596


mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql

668


What is pls_integer in pl sql?

635


What are the usages of sql?

661


what is the command used to fetch first 5 characters of the string? : Sql dba

1262