I want to know last five transactions or records from emp
table, from now?
- 11 Answers
- 19168 Views
- Wells Fargo, I also Faced
- E-Mail Answers
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
Differentiate pl/sql and sql?
What are the types of records?
What is an index? What are the types of indexes? How many clustered indexes can be created on a table?
What packages are available to pl/sql developers?
What is set serveroutput on in pl sql?
What are the disadvantages of not performing database normalization?
How can I get the number of records affected by a stored procedure?
What is full form of rtm?
What is sqlite format?
How to connect a sql*plus session to an oracle server?
When is a declare statement required?
How much ram can sql express use?
tell us something about heap tables. : Sql dba
What is the use of sql trace?
What are database links used for?
