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

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

Question Posted / sainaresh81

11 Answers
17803 Views
Wells Fargo, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

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

Answer / prakash r

Hi,

Please try the below query

Table
------
create table TEMP_SEARCH
(
F1 VARCHAR2(100),
F2 VARCHAR2(100),
F3 VARCHAR2(100)
)

select * from TEMP_SEARCH

Rownum F1 F2 F3
-----------------------------
1 1 500 DES1
2 2 600 DES2
3 3 550 DES3
4 4 760 DES4
5 5 899 DES5

select * from temp_search
minus
(select * from temp_search where rownum < (select count(*) -
2 from temp_search))

This will give the last two transaction

Is This Answer Correct ?

2 Yes

7 No

Post New Answer