I want to know last five transactions or records from emp
table, from now?
Answer Posted / sidhu
For ex: emp table, we want last five transaction in emp
select * from emp
minus
select * from emp where rownum <= (select count(*)-&n from emp);
this will work and give the value 5 it will return last five transacitons.
hope this helpful
Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Which is faster count (*) or count 1?
Who is the owner of mysql database?
Define commit?
What is trigger in sql? Explain
how to enter characters as hex numbers? : Sql dba
what are the types of join and explain each? : Sql dba
What is db journal file?
What is the purpose of my sql?
Explain the the update statement in sql?
Do we need to rebuild index after truncate?
GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?
Why do we use partitions in sql?
What are joins in sql?
What is the difference between left and left outer join?
how to convert character strings to numeric values? : Sql dba